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.  
 
 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)

< / Html>