Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Reference » SQL data types » Date and time data types


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)

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.