Icon DayTimeIntervalToSQLStr Method

System::UnicodeString __fastcall DayTimeIntervalToSQLStr(__int64
      Value, TEDBDayTimeIntervalType DayTimeIntervalType)

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