Contents Index MIN_TABLE_SIZE_FOR_HISTOGRAM option [database] NON_KEYWORDS option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

NEAREST_CENTURY option [compatibility]


Function 

Controls the interpretation of two-digit years in string-to-date conversions.

Allowed values 

Integer, between 0 and 100 inclusive.

Default 

50 for databases created with Version 6 or later.

0 for databases created with Version 5.5 or earlier.

Description 

This option controls the handling of two-digit years when converting from strings to dates or timestamps.

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.

The historical Adaptive Server Anywhere behavior is to add 1900 to the year. Adaptive Server Enterprise behavior is to use the nearest century, so any year where value yy is less than 50, the year is set to 20yy.


Contents Index MIN_TABLE_SIZE_FOR_HISTOGRAM option [database] NON_KEYWORDS option [compatibility]