Expressions.expr-primary-odbc-datetime

A date, time, or timestamp value.

Format

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

Remarks

Specifies a date, time, or timestamp value.

The DATE, TIME, or TIMESTAMP keyword is followed 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.