SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-38
Interval Data Types and Literals
Interval Data Types and Literals
NonStop SQL/MX supports the SQL:1999 INTERVAL data type. NonStop SQL/MX
recognizes the nonstandard FRACTION keyword used in NonStop SQL/MP and maps
it to the equivalent fractional portion of the standard SECOND field. However, it does
not support interval data types with a start field of FRACTION.
This table lists the mapping between the interval data types used in NonStop SQL/MP
and those used in NonStop SQL/MX:
DATETIME MONTH TO SECOND Yes (None)
DATETIME MONTH TO FRACTION(n) Yes (None)
DATETIME DAY Yes (None)
DATETIME DAY TO HOUR Yes (None)
DATETIME DAY TO MINUTE Yes (None)
DATETIME DAY TO SECOND Yes (None)
DATETIME DAY TO FRACTION(n) Yes (None)
DATETIME HOUR Yes (None)
DATETIME HOUR TO MINUTE Yes (None)
DATETIME HOUR TO SECOND Yes (None)
DATETIME HOUR TO FRACTION(n) Yes (None)
DATETIME MINUTE Yes (None)
DATETIME MINUTE TO SECOND Yes (None)
DATETIME MINUTE TO FRACTION(n) Yes (None)
DATETIME SECOND Yes (None)
DATETIME SECOND TO FRACTION(n) Yes (None)
DATETIME FRACTION TO FRACTION(n) No* (None)
INTERVAL SECOND(0) TO FRACTION (n) No* (None)
INTERVAL FRACTION TO FRACTION (n) No* (None)
INTERVAL start to FRACTION(n) Yes INTERVAL start to
SECOND(n)
All other INTERVAL start-end combinations Yes Same as in SQL/MP
*Limited support as dummy values in SELECT statements only
Table 10-9. SQL/MX Support for SQL/MP DATETIME Literals (page 2 of 2)
SQL/MP DATETIME Type
Supported
in SQL/MX Maps To ANSI Type