Contents Index Transact-SQL compatibility of string-to-date/time conversions Comparing dates and times in the database

ASA SQL Reference
  SQL Data Types
    Date and time data types

Retrieving dates and times from the database


Dates and times may be retrieved from the database in one of the following ways:

When a date or time is retrieved as a string, it is retrieved in the format specified by the database options DATE_FORMAT, TIME_FORMAT and TIMESTAMP_FORMAT. For descriptions of these options, see SET OPTION statement.

For information on functions that deal with dates and times, see Date and time functions. The following arithmetic operators are allowed on dates:


Contents Index Transact-SQL compatibility of string-to-date/time conversions Comparing dates and times in the database