century

The century property specifies how to expand abbreviated one- and two-digit year specifications in a DATE and DATETIME field.

Purpose

Usage

Expansion is based on this setting (and on the year value from the system clock at runtime).

The century property can specify any of four algorithms to expand abbreviated years into four-digit year values that end with the same digits (or digit) that the user has entered.

century supports the same settings as the DBCENTURY environment variable, but with a scope that is restricted to a single field.

If the century and DBCENTURY settings are different, CENTURY takes precedence.

Unlike DBCENTURY, the century property is not case sensitive. However, we recommend that you use uppercase letters in the property.