How dates are stored

Dates containing year values are used internally and stored in SQL 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 before 1600-02-28 23:59:59 and after 7911-01-01 00:00:00)
Note

When the precision of the TIMESTAMP is dropped, builtin functions that pertain to minutes or seconds will produce meaningless results.

For more information about SQL Anywhere date and time data types see Date and time data types.