1.194 Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT

Valid For

Extract and Replicat

Description

Use the Y2KCENTURYADJUSTMENT and NOY2KCENTURYADJUSTMENT parameters to control the conversion of year values when the century portion consists of zeroes (such as 0055) or is not specified (such as in a two-digit, year-only specification).

With Y2KCENTURYADJUSTMENT enabled (the default), a two-digit year value that is greater than or equal to 50 is converted to a four-digit year in the 20th century (19xx). If a two-digit year value is less than 50, it is converted to a four-digit year in the 21st century (20xx).If the century portion of the year is non-zero, or if NOY2KCENTURYADJUSTMENT is specified, no conversion is performed.

Default

Y2KCENTURYADJUSTMENT

Syntax

Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT