Guest User

Untitled

a guest
Apr 25th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. select * from order
  2. join timmingSettings on order.timmingSettings = timmingSettings.id
  3. where (order.time-timmingSettings.timeout) < current_timestamp
  4.  
  5. public class TimeFunc
  6. {
  7. public static long getSeconds(java.sql.Timestamp ts)
  8. {
  9. return ts.getTime() / 1000;
  10. }
  11. }
  12.  
  13. CREATE ALIAS TIME_SECS FOR "TimeFunc.getSeconds";
  14.  
  15. SELECT TIME_SECS(CURRENT_TIMESTAMP);
  16.  
  17. TIME_SECS(CURRENT_TIMESTAMP())
  18. 1255862217
  19. (1 row, 0 ms)
Add Comment
Please, Sign In to add comment