Neoview SQL Reference Manual (R2.4)

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:
Year, from 0001 to 9999
yyyy
Month, from 01 to 12
mm
Day, from 01 to 31
dd
Hour, from 00 to 23
hh
Minute, from 00 to 59
mm
Second, from 00 to 59
ss
Microsecond, from 000000 to 999999
msssss
When you specify datetime_value (FORMAT ‘string’) in the DML statement and the
specified format is ‘mm/dd/yyyy’,’MM/DD/YYYY’, or ‘yyyy/mm/dd’ or ‘yyyy-mm-dd’, the
datetime type is automatically cast.
236 SQL Language Elements