Icon YearMonthIntervalToSQLStr Method

System::UnicodeString __fastcall YearMonthIntervalToSQLStr(int
      Value, TEDBYearMonthIntervalType YearMonthIntervalType)

Call the YearMonthIntervalToSQLStr method to convert a TEDBYearMonthInterval (Integer) value to an SQL 2003 standard year-month interval constant string. All SQL and filter expressions in ElevateDB require standard year-month interval constants which use the general 'yyyy-mm' format. Use the YearMonthIntervalType parameter to indicate how the year-month interval should be formatted.

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