Contents Index Year 2000 compliance Sending and retrieving date values

ASA SQL Reference
  SQL Data Types
    Year 2000 compliance

How dates are stored


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.


Contents Index Year 2000 compliance Sending and retrieving date values