Expressions.expr-primary-datetime

A date, time or timestamp value

Format

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