Manualshelf

SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series
919293949596979899100
the data type, its meaning, and the range of data allowed in fields of a value of this type. The
fields in these data types are not equivalent to columns.
A column value of type DATE is made up of these contiguous fields:
0001 to 9999YearYEAR
01 to 12Month of yearMONTH
01 to 31Day of MonthDAY
The maximum value of DAY depends on the length of the month.
An item of type TIME indicates a time of day based on a 24-hour clock and is made up of these
contiguous fields:
00 to 23Hour of dayHOUR
00 to 59Minute of hourMINUTE
00 to 59Second of minuteSECOND
A column value of type TIMESTAMP is made up of these fields:
0001 to 9999YearYEAR
01 to 12Month of yearMONTH
01 to 31Day of monthDAY
00 to 23Hour of dayHOUR
00 to 59Minutes of hourMINUTE
00 to 59Second of minuteSECOND*
*The SECONDS field can have an optional fractional part of from zero to six digits in length.
The maximum value of DAY depends on the length of the month.
A column value of type INTERVAL is made up of these contiguous fields:
Not constrainedNumber of yearsYEAR
Constrained to 01 through 12 if a YEAR field value is present but is
otherwise not constrained
Number of monthsMONTH
or
Not constrainedNumber of daysDAY
00 to 23. Constrained only if the DAY field value is present.Number of hoursHOUR
00 to 59. Constrained only if the HOUR field value is present.Number of minutesMINUTE
00 to 59. Constrained only if MINUTE field value is present.Number of secondsSECOND*
*The SECOND field can have an optional fractional part of from zero to six digits in length.
An INTERVAL column is defined to have a range of these contiguous fields, specified by a required
start-date-time field and an optional end-date-time field. You can specify a precision for any
start-date-time field.
NOTE: NonStop SQL/MX does not support the use of columns of the SQL/MP type DATETIME
in SQL/MX tables or views. However, you can use SQL/MX datetime functions to select individual
fields from any DATETIME column in an SQL/MP table except FRACTION-only. For more information
about using SQL/MX datetime functions on DATETIME data, see the SQL/MX Reference Manual.
92 Creating an SQL/MX Database