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

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-24
Datetime Data Types
Considerations for Datetime Data Types
Datetime Ranges
The range of values for the individual fields in a DATE, TIME, or TIMESTAMP column
is specified as:
SQL/MP Considerations for Datetime Data Types Not
Equivalent to DATE, TIME, TIMESTAMP
When accessing SQL/MP DATETIME columns, you can:
•
Select SQL/MP DATETIME columns that are not equivalent to DATE, TIME, or
TIMESTAMP.
•
Insert into or update SQL/MP DATETIME columns with literals that are not
equivalent to DATE, TIME, or TIMESTAMP.
The SQL/MP DATETIME columns that do not map to standard SQL/MX types are
represented as SQL/MP DATETIME types in NonStop SQL/MX. These types are:
•
DATETIME YEAR
•
DATETIME YEAR TO MONTH
•
DATETIME YEAR TO HOUR
•
DATETIME YEAR TO MINUTE
•
DATETIME MONTH
•
DATETIME MONTH TO DAY
•
DATETIME MONTH TO HOUR
•
DATETIME MONTH TO MINUTE
•
DATETIME MONTH TO SECOND
•
DATETIME MONTH TO FRACTION(n)
•
DATETIME DAY
•
DATETIME DAY TO HOUR
•
DATETIME DAY TO MINUTE
•
DATETIME DAY TO SECOND
•
DATETIME DAY TO FRACTION(n)
•
DATETIME HOUR
•
DATETIME HOUR TO MINUTE
•
DATETIME HOUR TO SECOND
yyyy Year, from 0001 to 9999
mm Month, from 01 to 12
dd Day, from 01 to 31
hh Hour, from 00 to 23
mm Minute, from 00 to 59
ss Second, from 00 to 59
msssss Microsecond, from 000000 to 999999