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.