CENTURY

The first four-digit year value must be less than the second four-digit year. You must specify both values, and the values must span 100 years.

You can also specify CENTURY on the field specification option if you want to apply it to a particular DATE or TIMESTAMP column. For more information, see the individual data type.

Specifying the default

You can specify the default for the CENTURY command option in your installation options module by using the CENTURY installation option. UNLOAD PLUS was shipped with a default value of (1950,2049) for this option. The command option overrides the default that is in the installation options module.

(ccyy,ccyy)

Any two-digit year in the data that you are unloading that lies between the first yy specification and 99 is prefixed with the first cc value to create a four-digit year. Any two-digit year in the data that you are unloading that lies between 00 and the second yy specification is prefixed with the second cc value to create a four-digit year.

For example, if you specify CENTURY(1950,2049), UNLOAD PLUS places 19 in front of each two-digit year with a value of 50 through 99 and places 20 in front of each two-digit year with a value of 00 through 49. The date 99/12/31 becomes 1999/12/31 and 00/12/31 becomes 2000/12/31.