To configure the sliding date window for Year 2000 dates and help convert non-Y2K legacy date data, set the following values:
YEARWINDOW=nn
Enter the desired year-window where nn represents the dividing year between centuries.
Interpretation using the default value of 40 years:
Dates nn/nn/59 to nn/nn/99 are seen as 1959 to 1999.
Dates nn/nn/00 to nn/nn/58 are seen as 2000 to 2058.
The YearWindow setting affects the data types shown in the following table:
Sliding Date Window Data Types
|
CONNX Data Type |
SQL Data Type |
Length |
Description |
|
Text Date 2000 (YYMMDD) |
DATE |
6 |
Text Date in the specified format. Handles years 1941 to 2040. |
|
Text Date 2000 (MMDDYY) |
DATE |
6 |
Text Date in the specified format. Handles years 1941 to 2040. |
|
Text Date 2000 (DDMMYY) |
DATE |
6 |
Text Date in the specified format. Handles years 1941 to 2040. |
|
Long Date 2000 (YYMMDD) |
DATE |
6 |
Long Date in the specified format. Handles years 1941 to 2040. |
|
Long Date 2000 (MMDDYY) |
DATE |
6 |
Long Date in the specified format. Handles years 1941 to 2040. |
|
Long Date 2000 (DDMMYY) |
DATE |
6 |
Long Date in the specified format. Handles years 1941 to 2040. |
|
Packed Date 2000 (YYMMDD) |
DATE |
4 |
Packed Date in the specified format. Handles years 1941 to 2040. |
|
Packed Date 2000 (MMDDYY) |
DATE |
4 |
Packed Date in the specified format. Handles years 1941 to 2040. |
|
Packed Date 2000 (DDMMYY) |
DATE |
4 |
Packed Date in the specified format. Handles years 1941 to 2040. |
Default = 40 years.
Environment: Client, Windows, Unix
Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name = YearWindow
Unix Registry Setting: CONNX.YEARWINDOW