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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options


date_order option [database]

Controls the interpretation of date formats.

For more information about setting the format for dates retrieved from the database, see date_format option [database].

Allowed values



YMD (this corresponds to ISO date format specifications)

For Open Client and jConnect connections, the default is set to MDY


Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.


The database option date_order is used to determine whether 10/11/12 is Oct 11 1912, Nov 12 1910, or Nov 10 1912.


If you change the setting for date_order in a way that re-orders the date format, be sure to change the date_format and timestamp_format options to reflect the same change, and vice versa. See date_format option [database], and timestamp_format option [compatibility].