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-37
Date-Time Data Types and Literals
Supported and Unsupported SQL/MP Date-Time Literals in
NonStop SQL/MX
SQL/MP date-time literals fall into one of these categories:
•
Those that map directly to SQL:1999 types and are supported by NonStop
SQL/MX
•
Those that do not map to SQL:1999 types but are supported by NonStop SQL/MX
•
Those that do not map to SQL:1999 types and are not supported in NonStop
SQL/MX
SQL/MP date-time literals that are not supported are listed in Table 10-9
:
:
Table 10-9. SQL/MX Support for SQL/MP DATETIME Literals (page 1 of 2)
SQL/MP DATETIME Type
Supported
in SQL/MX Maps To ANSI Type
DATETIME YEAR TO DAY Yes DATE
DATETIME YEAR TO SECOND Yes TIMESTAMP(0)
DATETIME YEAR TO FRACTION (1) Yes TIMESTAMP(1)
DATETIME YEAR TO FRACTION (2) Yes TIMESTAMP(2)
DATETIME YEAR TO FRACTION (3) Yes TIMESTAMP(3)
DATETIME YEAR TO FRACTION (4) Yes TIMESTAMP(4)
DATETIME YEAR TO FRACTION (5) Yes TIMESTAMP(5)
DATETIME YEAR TO FRACTION (6) Yes TIMESTAMP(6)
DATETIME HOUR TO SECOND Yes TIME(0)
DATETIME HOUR TO FRACTION (1) Yes TIME(1)
DATETIME HOUR TO FRACTION (2) Yes TIME(2)
DATETIME HOUR TO FRACTION (3) Yes TIME(3)
DATETIME HOUR TO FRACTION (4) Yes TIME(4)
DATETIME HOUR TO FRACTION (5) Yes TIME(5)
DATETIME HOUR TO FRACTION (6) Yes TIME(6)
DATETIME YEAR Yes (None)
DATETIME YEAR TO MONTH Yes (None)
DATETIME YEAR TO HOUR Yes (None)
DATETIME YEAR TO MINUTE Yes (None)
DATETIME MONTH Yes (None)
DATETIME MONTH TO DAY Yes (None)
DATETIME MONTH TO HOUR Yes (None)
DATETIME MONTH TO MINUTE Yes (None)