DATE
This keyword defines a date field. DATE specifies a Db2 internal date format.
For more information, see Additional-date-time-or-timestamp-field-considerations.
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 50 through 99, and places 20 in front of each two-digit year with a value 00 through 49. The date 99/12/31 becomes 1999/12/31 and 00/12/31 becomes 2000/12/31. |
|---|
Related topic