Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT
Valid for
Extract, Replicat
Description
Use Y2KCENTURYADJUSTMENT
to enable the Y2K window to change the century. By default the column conversion functions that deal with dates put a Y2K window on a two-digit year when the century is zero. If the two-digit year is greater than 49
, then the century becomes 19
. If the year is 49
or less, the century becomes 20
. This damages input date times such as 0001-01-01:00:00:00.000000
by making the century 20
, and producing the incorrect result: 2001-01-01:00:00:00.000000
.
Use NOY2KCENTURYADJUSTMENT
to prevent the Y2K window from changing the century. Enter before relevant date calculations.
NOY2KCENTURYADJUSTMENT
does not have an effect if the century field is not present at all. When the century field is not present, the century will be assigned a value based on the year. When the year is greater than 49
, the century is set to 19
; otherwise it will default to 20
.
Default
Y2KCENTURYADJUSTMENT
Syntax
Y2KCENTURYADJUSTMENT | NOY2KCENTURYADJUSTMENT