|
Controls the interpretation of two-digit years in string-to-date conversions. It is used when converting from strings to dates or timestamps.
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 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. |
Integer, between 0 and 100 inclusive
50
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.