ODBC defines escape sequences containing standard grammar for date, time, timestamp, and datetime interval literals, scalar function calls, LIKE predicate escape characters, outer joins, and procedure calls. Interoperable applications should use these sequences whenever possible.
To determine if a driver supports the escape sequences for date, time, timestamp, or datetime interval literals, an application calls SQLGetTypeInfo. If the data source supports a date, time, timestamp, or datetime interval data type, it must also support the corresponding escape sequence. To determine if the other escape sequences are supported, an application calls SQLGetInfo.
For more information, see “Escape Sequences in ODBC,” later in this chapter.