DatabaseServices.makeJDBCTimeStringFromField

Creates a SQL escape string in the format {t 'hh:mm:ss'} from a form field of type Date, DateTime or Time. This can be used in conjunction with the #executeGenericUpdateStatement(String, String) or #executeSelectStatement(String, String, SelectStatementCallback) methods;

Example:

 var t2 = new Date(fields.orderTime.value);
 var stmt = "select * from orders where order_time = "
    + services.database.makeJDBCTimeStringFromField(fields.orderTime); 
 services.database.executeSelectStatement("SAMPLES", stmt, function (columnData) {..});