Icon DateTimeToSQLStr Method

function DateTimeToSQLStr(Value: TDateTime; MilitaryTime:
      Boolean=True): String

Call the DateTimeToSQLStr method to convert a TDateTime value to an SQL 2003 standard timestamp constant string. All SQL and filter expressions in ElevateDB require standard timestamp constants which use the 'yyyy-mm-dd hh:mm:ss.zzz am/pm' format. Use the MilitaryTime parameter to indicate whether the time should be returned in 24-hour format instead of 12-hour format with an am/pm indicator.

Please see the Types topic for more information on the data types in ElevateDB and their literal representation.
Image