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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

UltraLite date_format property Next Page

UltraLite date_order property

Controls the interpretation for the order of months, days, and year date parts.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use any utility that creates a database.

Use the following property syntax:

- o date_order=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Options page, set the Date Order option .

From a client application    Use the create database method.

Set this property as one of the creation parameters for an API's create database method on the database manager class.

Allowed values



YMD, which corresponds to ISO date format specifications.


You cannot change the date order of an existing database. Instead, you must create a new database.

See also

Different values determine what the date of 10/11/12 is translated as:

Syntax usedTranslation
MDY Oct 11 1912
YMDNov 12 1910
DMYNov 10 1912