Expressions.expr-primary-odbc-datetime

Use the D, T, or TS keywords to specify a date, time, or timestamp value.

Format

{{ { D | T | TS } { 'DateTime' | ? | ( DateTimeExpr ) } }}

Remarks

Follow the D, T, or TS keyword by the DateTime value.

The DateTime value can be one of the following:

• A string literal defining the date, time, or timestamp value.
• A parameter marker.
• A string expression enclosed in parentheses.

The resulting string is interpreted as an SQL date, time, or timestamp literal. The following table describes the required format for each type:

For T and TS types, the fractional seconds part [.FFFFFF] is optional.