SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-26
Datetime Data Types
-------------
######
######
...
NonStop SQL/MX returns a warning indicating that you selected an unsupported data
type with undefined contents.
SQL/MP Considerations for Datetime Data Types Equivalent
to DATE, TIME, TIMESTAMP
When accessing SQL/MP DATETIME columns, you can:
•
Select SQL/MP DATETIME columns that are equivalent to DATE, TIME, or
TIMESTAMP.
•
Insert into or update SQL/MP DATETIME columns with equivalent DATE, TIME, or
TIMESTAMP literals
The SQL/MP DATETIME columns that map to standard SQL/MX types are
represented as standard types in NonStop SQL/MX. As a result, the behavior of these
SQL/MP data types might be different within NonStop SQL/MX compared to their
behavior in NonStop SQL/MP.
The equivalent mappings are:
SQL/MP DATETIME Type Equivalent SQL/MX Type
DATETIME YEAR TO DAY DATE
DATETIME YEAR TO SECOND TIMESTAMP(0)
DATETIME YEAR TO FRACTION(1) TIMESTAMP(1)
DATETIME YEAR TO FRACTION(2) TIMESTAMP(2)
DATETIME YEAR TO FRACTION(3) TIMESTAMP(3)
DATETIME YEAR TO FRACTION(4) TIMESTAMP(4)
DATETIME YEAR TO FRACTION(5) TIMESTAMP(5)
DATETIME YEAR TO FRACTION(6) TIMESTAMP(6) or TIMESTAMP
DATETIME HOUR TO SECOND TIME(0) or TIME
DATETIME HOUR TO FRACTION(1) TIME(1)
DATETIME HOUR TO FRACTION(2) TIME(2)
DATETIME HOUR TO FRACTION(3) TIME(3)
DATETIME HOUR TO FRACTION(4) TIME(4)
DATETIME HOUR TO FRACTION(5) TIME(5)
DATETIME HOUR TO FRACTION(6) TIME(6)