Expressions.expr-primary-odbc-datetime

A date, time or timestamp value

Format

{{ { D | T | TS } { 'Interval' | ? | ( IntervalExpr ) } }}

Remarks

Specifies a date, time or timestamp value.

The DATE, TIME, or TIMSTAMP keyword is followed by the DateTime value.

The DateTime value can be one of the following:

• A string literal defining the interval 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