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

SQL Anywhere 12.0.0 » SQL Anywhere Server - 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:

  • Using any interface, as a string

  • Using ODBC, as a TIMESTAMP structure

  • Using embedded SQL, as a SQLDATETIME structure

Date and times with time zone offsets may be retrieved from the database as a string only.

When a date or time, with or without a time zone offset, is retrieved as a string, it is retrieved in the format specified by the database options date_format, time_format, timestamp_format, and timestamp_with_time_zone_format. For descriptions of these options, see SET OPTION statement.

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

  • timestamp + integer   Add the specified number of days to a date or timestamp.

  • timestamp - integer   Subtract the specified number of days from a date or timestamp.

  • date - date   Compute the number of days between two dates or timestamps.

  • date + time   Create a timestamp combining the given date and time.

 Leap Years