ASA SQL Reference
SQL Data Types
Year 2000 compliance
Dates containing year values are used internally and stored in Adaptive Server Anywhere databases using either of the following data types:
Data type | Contains | Stored in | Range of possible values |
---|---|---|---|
DATE | Calendar date (year, month, day) | 4-bytes | 0001-01-01 to 9999-12-31 |
TIMESTAMP | Time stamp (year, month, day, hour minute, second, and fraction of second accurate to 6 decimal places) | 8-bytes | 0001-01-01 to 9999-12-31 (precision of the time portion of TIMESTAMP is dropped prior to 1600-02-28 23:59:59 and after 7911-01-01 00:00:00) |
For more information on Adaptive Server Anywhere date and time data types see Date and time data types.