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 timestamp considerations Next Page

UltraLite nearest century conversion considerations


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. In the case of a two-digit date, you need to set the appropriate rollover value.

Choosing an appropriate rollover value typically is determined by:

If this option is not set, the default setting of 50 is assumed. Thus, two-digit year strings are understood to refer to years between 1950 and 2049.

See also