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.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |