Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » SQL data types

 

Date and time data types

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

  • Correct values are always returned for any legal arithmetic and logical operations on dates, regardless of whether the calculated values span different centuries.

  • The internal storage of dates always explicitly includes the century portion of a year value.

  • Date values can always be output in full century format.


How date and time of day are stored
Ways to send dates and times to the database
Retrieval of dates and times from the database
DATE data type
DATETIME data type
DATETIMEOFFSET data type
SMALLDATETIME data type
TIME data type
TIMESTAMP data type
TIMESTAMP WITH TIME ZONE data type