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 about SQL Anywhere date and time data types see Date and time data types.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |