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

VARBIT data type Next Page

Date and time data types


This section examines how date values are handled internally by SQL Anywhere, and how SQL Anywhere handles ambiguous date information, such as the conversion of a two digit year string value.

The following list provides a quick overview of how dates are handled:


How dates are stored
Sending dates and times to the database
Retrieving dates and times from the database
Comparing dates and times
Using unambiguous dates and times
DATE data type
DATETIME data type
SMALLDATETIME data type
TIME data type
TIMESTAMP data type