Icon YearMonthIntervalToSQLStr Method

function YearMonthIntervalToSQLStr(Value: TEDBYearMonthInterval;
      YearMonthIntervalType: TEDBYearMonthIntervalType): String

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