Controls the interpretation of date formats.

Syntax

{ ulcreate | ulinit | ulload } -o date_order=value;...

Allowed values

MDY, YMD, DMY

Default

YMD (this corresponds to ISO date format specifications)

Remarks

DATE data type values are represented in a format set by the date_format creation parameter. Date values can, however, also be represented by strings. Before the value can be retrieved, it must be assigned to a string.

UltraLite builds a date from date parts. Date parts can include the year, the month, the day of the month, the day of the week, the day of the year, the hour, the minute, and the second (and parts thereof).

ISO (YYYY-MM-DD) is the default date format and order. For example, "7th of January 2006" in this international format is written: 2006-01-07. If you do not want to use the default ISO date format and order, you must specify a different format and order for these date parts.

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

From Sybase Central, you can set the date order in any wizard that creates a database. On the New Database Options page, select the Date Order option.

From a client application, set this parameter as one of the creation parameters for the create database method on the database manager class.

See also

• UltraLite date_format creation parameter
• UltraLite Create Database utility (ulcreate)
• UltraLite Initialize Database utility (ulinit)
• UltraLite Load XML to Database utility (ulload)
• UltraLite for embedded SQL: ULCreateDatabase function
• UltraLite for C++: CreateDatabase function
• UltraLite.NET: CreateDatabase method
• UltraLite for M-Business Anywhere: createDatabase method
• Accessing creation parameter values

Example

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