DatabaseServices.makeJDBCTimestampString

Creates a SQL escape string for a timestamp field in the format {ts 'yyyy-mm-dd hh:mm:ss.fff'}. An Ebase field of type DateTime is equivalent to a database timestamp column. This method can be used in conjunction with the #executeGenericUpdateStatement(String, String) or #executeSelectStatement(String, String, SelectStatementCallback) methods;

Example:

 var ts1 = new Date();
 var stmt = "update orders set order_timestamp = " 
    + services.database.makeJDBCTimestampString(ts1)
    + " where order_id = " + orderId; 
 services.database.executeGenericUpdateStatement("SAMPLES", stmt);