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 » Creating and Configuring UltraLite Databases » Choosing creation-time database properties for UltraLite

UltraLite case sensitivity considerations Next Page

UltraLite date considerations


Values whose data types are DATE are represented in a format set by the date_format property. Date values can, however, also be represented by strings. Before it can be retrieved, a date value must be assigned to a string variable.

Date parts you can use

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, the second (and parts thereof).

Use the date_order property to arrange these date parts in a specific order.

ISO (that is, 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.

See also