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 max_hash_size property Next Page

UltraLite nearest_century property

Controls the interpretation of two-digit years in string-to-date conversions. It is used when converting from strings to dates or timestamps.

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 nearest_century=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Options page, set the Nearest Century 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

Integer, between 0 and 100 inclusive




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

The nearest_century setting is a numeric value that acts as a rollover point. Two digit years less than the value are converted to 20yy, while years greater than or equal to the value are converted to 19yy.

See also