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 » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite 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.


DATE data type
DATETIME data type
TIME data type
TIMESTAMP data type
TIMESTAMP WITH TIME ZONE data type