TIMESTAMP
This keyword specifies a timestamp field.
For more information, see Additional-date-time-or-timestamp-field-considerations.
TIMESTAMP
TIMESTAMP specifies a Db2 internal timestamp format.
TIMESTAMP EXTERNAL (length)
This option specifies a Db2 timestamp string value.
TIMESTAMP-format EXTERNAL (length)
This option specifies a Db2 timestamp string. In addition, it specifies the format of the timestamp in the column value, not the format of the field. The column must be CHARACTER only. For information about the available timestamp formats, see Supported-DATE-TIME-and-TIMESTAMP-formats.
When using DIRECT NO, specifying TIMESTAMP-format EXTERNAL(length) requires extra consideration due to the various ways in which the data is returned from Db2. Often, the same TIMESTAMP-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 TIMESTAMP 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 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. |
|---|
TIMESTAMP WITH TIME ZONE
TIMESTAMP specifies a Db2 internal timestamp with time zone format.
TIMESTAMP WITH TIME ZONE EXTERNAL (length)
This option specifies a Db2 timestamp with time zone string value.
Related topic