Icon SQLStrToYearMonthInterval Method

function SQLStrToYearMonthInterval(const Value: String;
      YearMonthIntervalType: TEDBYearMonthIntervalType):
      TEDBYearMonthInterval

Call the SQLStrToYearMonthInterval method to convert a string that contains an SQL 2003 standard year-month interval constant to an actual TEDBYearMonthInterval (Integer) value. All SQL and filter expressions in ElevateDB require standard year-month interval constants which use the 'yyyy-mm' format.

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