Icon TimeToSQLStr Method

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

Call the TimeToSQLStr method to convert a TDateTime value to an SQL 2003 standard time constant string. All SQL and filter expressions in ElevateDB require standard time constants which use the '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