SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-7
Date-time Literals
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)
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)
Table 3-1. Support For NonStop SQL/MP DATETIME Literals in NonStop
SQL/MX (page 2 of 3)
NonStop SQL/MP DATETIME Type
Supported
in NonStop
SQL/MX Maps To ANSI Type