Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from order
- join timmingSettings on order.timmingSettings = timmingSettings.id
- where (order.time-timmingSettings.timeout) < current_timestamp
- public class TimeFunc
- {
- public static long getSeconds(java.sql.Timestamp ts)
- {
- return ts.getTime() / 1000;
- }
- }
- CREATE ALIAS TIME_SECS FOR "TimeFunc.getSeconds";
- SELECT TIME_SECS(CURRENT_TIMESTAMP);
- TIME_SECS(CURRENT_TIMESTAMP())
- 1255862217
- (1 row, 0 ms)
Add Comment
Please, Sign In to add comment