ODBC Escape Sequences

To specify times, dates, timestamps and functions in an SQL statement you may use either the specific format for the ODBC driver you are using or else an escape sequence. The escape sequence translates a uniform specifier to the syntax used by the ODBC driver.

Select {d '1999-12-31'} As MyDate Select {t '23:59:59'} As MyTime Select {ts '1999-12-31 23:59:59'} As MyTimestamp Select {fn Sin(0.5)} As SineHalf {call MyProcedure(1, 2, 3)}