SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—523725-004
6-45
Interval Value Expressions
Interval Value Expressions
SQL/MP Considerations for Interval Value Expressions
Considerations for Interval Value Expressions
Examples of Interval Value Expressions
The operands of an interval value expression can be combined in specific ways with
addition and subtraction operators. In this syntax diagram, the data type of a datetime
expression is DATE, TIME, or TIMESTAMP; the data type of an interval term or
expression is INTERVAL.
interval-expression is:
interval-term
| interval-expression + interval-term
| interval-expression - interval-term
| (datetime-expression - datetime-primary)
[interval-qualifier]
interval-term is:
interval-factor
| interval-term * numeric-factor
| interval-term / numeric-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)
numeric-factor is:
[+|-] numeric-primary
| [+|-] numeric-primary ** numeric-factor