iAnywhere.com - UltraLite date

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

UltraLite employs different methods for setting this property:

Context	Implemented 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.

Context

Implemented 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.

MDY, YMD, DMY

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.

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