SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-39
Datetime Value Expressions
Datetime Value Expressions
SQL/MP Considerations for Datetime Value Expressions
Considerations for Datetime Value Expressions
Examples of Datetime Value Expressions
The operands of a datetime value expression can be combined in specific ways with
arithmetic operators.
In this syntax diagram, the data type of a datetime primary is DATE, TIME, or
TIMESTAMP. The data type of an interval term is INTERVAL.
datetime-expression is:
datetime-primary
| interval-expression + datetime-primary
| datetime-expression + interval-term
| datetime-expression - interval-term
datetime-primary is:
datetime-literal
| column-reference
| datetime-type-host-variable
| dynamic parameter
| datetime-value-function
| aggregate-function
| sequence-function
| scalar-subquery
| CASE-expression
| CAST-expression
| (datetime-expression)
interval-term is:
interval-factor
| numeric-term * interval-factor
interval-factor is:
[+|-] interval-primary
interval-primary is:
interval-literal
| column-reference
| interval-type-host-variable
| dynamic parameter
| aggregate-function
| sequence-function
| scalar-subquery
| CASE-expression
| CAST-expression
| (interval-expression)