Icon DayTimeIntervalToSQLStr Method

function DayTimeIntervalToSQLStr(Value: TEDBDayTimeInterval;
      DayTimeIntervalType: TEDBDayTimeIntervalType): String

Call the DayTimeIntervalToSQLStr method to convert a TEDBDayTimeInterval (Int64) value to an SQL 2003 standard day-time interval constant string. All SQL and filter expressions in ElevateDB require standard day-time interval constants which use the general 'dd hh:mm:ss.zzz am/pm' format. Use the DayTimeIntervalType parameter to indicate how the day-time interval should be formatted.

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