DATE
DATE EXTERNAL (length)
This option specifies a Db2 date string.
DATE- format EXTERNAL (length)
This option specifies a Db2 date string. In addition, it indicates the format of the external date in the column value, not the format of the field. The column must be CHARACTER, DECIMAL, or INTEGER. For information about available date formats, see Supported DATE, TIME, and TIMESTAMP formats.
When using DIRECT NO, specifying DATE-format EXTERNAL(length) requires extra consideration due to the various ways in which the data is returned from Db2. Often, the same DATE-format is not appropriate when using DIRECT YES versus DIRECT NO.
CENTURY(ccyy,ccyy) | CENTURY specifies the 100-year range that determines the century for DATE external formats that contain two-digit year values. The first four-digit year value must be less than the second four-digit year. You must specify both values, which must span 100 years. Any two-digit year between the first yy specification and 99 has the first cc value prefixed to create a four-digit year. Any two-digit year that is between 00 and the second yy specification has the second cc value prefixed 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. |
|---|