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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Data Types » Date and time data types

Date and time data types Next Page

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 prior to 1600-02-28 23:59:59 and after 7911-01-01 00:00:00)

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