Kbase 19248: How to force a 4-digit year when using the EXPORT statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/1999 |
|
How to force a 4-digit year when using the EXPORT statement.
The EXPORT statement will default to a 2-digit year for date fields, even though it is formatted for 4-digits in the Data Dictionary.
To force a 4-digit year to EXPORT, set the SESSION:YEAR-OFFSET equal
to a high number, such as 3000. This will force all dates
to fall outside the 100-year window governing the Progress
default century for 2-digit dates, and thus force the 4-digit year.
Setting the YEAR-OFFSET at the outset of the program changes that value for the procedure only. To change the value for running multiple procedures, set the value using the -yy startup parameter instead.
Also see K-base # 18505 which describes the V9 startup parameter
-yr4def.
Progress Software Technical Support Note # 19248