2.255 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