DatabaseServices.makeJDBCTimeString

Creates a SQL escape string for a time field in the format {t 'hh:mm:ss'}. This can be used in conjunction with the #executeGenericUpdateStatement(String, String) or #executeSelectStatement(String, String, SelectStatementCallback) methods;

Example:

 var t1 = new Date();
 var stmt = "update orders set order_time = "
    + services.database.makeJDBCTimeString(t1)
    + " where order_id = " + orderId; 
 services.database.executeGenericUpdateStatement("SAMPLES", stmt); 
 

returns java.lang.String

Parameters

java.util.Date  date,