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

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—523725-004
6-29
Datetime Data Types
Suppose that the current timestamp is 2000-01-26:10:24:10.212072. This expression
involves extension on both ends:
CAST(DATETIME '12-23' MONTH TO DAY AS TIMESTAMP)
The result of the CAST is 2000-12-23:00:00:00.000000.
Operations Equivalent to UNITS
The SQL/MP UNITS operator is not supported. However, NonStop SQL/MX does
support equivalent syntax.
Suppose that an SQL/MP table has a DATETIME column defined as:
MPDateTimeCol DATETIME MONTH TO DAY
DEFAULT DATETIME '03-12' MONTH TO DAY
Using this column as an example, you can specify this equivalent:
SQL/MP Element SQL/MX Equivalent
MPDateTimeCol UNITS MONTH MONTH(MPDateTimeCol)