The DATE data type is used to store calendar dates, such as a year, month and day.
The year can be from the year 0001 to 9999. The minimum date in SQL Anywhere is 0001-01-01 00:00:00.
For historical reasons, a DATE column can also contain an hour and minute. The TIMESTAMP data type is recommended for anything with hours and minutes.
The format in which DATE values are retrieved by applications is controlled by the date_format setting. For example, a date
value representing the 19th of July, 2010 may be returned to an application as
2010/07/19, or as
Jul 19, 2010.
The way in which a string is interpreted by the database server as a date is controlled by the date_order option. For example,
depending on the date_order setting, a value of
02/05/2002 supplied by an application for a DATE value may be interpreted in the database as the 2nd of May or the 5th of February.
A DATE value requires 4 bytes of storage.
SQL/2003 Vendor extension.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|