ulinit  --nearest_century=value

Integer, between 0 and 100, inclusive

50

UltraLite automatically converts a string into a date when a date value is expected, even if the year is represented in the string by only two digits. For a two-digit date, you need to set the appropriate rollover value. Two digit years less than the value are converted to 20yy, while years greater than or equal to the value are converted to 19yy.

Choosing an appropriate rollover value typically is determined by:

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

From Sybase Central, you can configure the nearest century setting in any wizard that creates a database. On the New database creation parameters page, select the Nearest Century option.

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

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