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