TIMESTAMP
TIMESTAMP
TIMESTAMP indicates a DB2 internal timestamp value.
TIMESTAMP EXTERNAL(length)
TIMESTAMP EXTERNAL indicates a Db2 timestamp string value.
TIMESTAMP-format EXTERNAL(length)
This data type description indicates an external timestamp value. In addition, it indicates the format of the external timestamp value. See Supported-external-DATE-TIME-and-TIMESTAMP-formats for information about the available timestamp formats.
When you specify TIMESTAMP-format EXTERNAL, LOADPLUS loads the current timestamp when the input data equates to spaces or zeros unless the column has a default value of null. If the column has a default value of null, LOADPLUS loads nulls instead of the current timestamp when the input data equates to spaces or zeros.
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 and these values must span 100 years. Any two-digit year in the input data 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 input data 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), LOADPLUS 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. For information about specifying CENTURY globally on the LOAD command, see CENTURY. For information about the CENTURY installation option, see CENTURY=(1950,2049). |
|---|
TIMESTAMP WITH TIME ZONE
This data type indicates a Db2 internal timestamp with a time zone value.
TIMESTAMP WITH TIME ZONE EXTERNAL (length)
This data type indicates a Db2 timestamp with a time zone string value.