Expressions.expr-primary-datetime

Use the DATE, TIME, or TIMESTAMP keywords to specify a date, time, or timestamp value.

Format

{ DATE | TIME | TIMESTAMP } { 'DateTime' | ? | ( DateTimeExpr ) }

Remarks

Follow the DATE, TIME, or TIMESTAMP 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 TIME and TIMESTAMP types, the fractional seconds part [.FFFFFF] is optional.