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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|