H2 database. How to convert date to seconds in sql? -
What's the time_to_sec () of analog and MySQL?
I would like to emphasize the query like the following H2 database:
Join order * Include in ordering from the order. Order settings.edtings = timingsSettings.id where (order.time-timmingSettings.timeout) & lt; If necessary, the function seems very easy to add.
< / Html>not
public time timefank {public static long milliseconds ( Java SQL.Temstamp) ts) {return ts.getTime () / 1000; }}
In Java code can be added to the H2 using the function ALIAS:
create ALIAS TIME_SECS for "TimeFunc.getSeconds"; Select TIME_SECS (CURRENT_TIMESTAMP);
Production:
TIME_SECS (CURRENT_TIMESTAMP ()) 1255862217 (1 line, 0 ms)
Comments
Post a Comment