Additional date, time, or timestamp field considerations

This topic describes additional considerations for the date, time, and timestamp fields.

A date, time, or timestamp EXTERNAL field produces a character representation of the date, time, or timestamp value, producing a EUR, ISO, JIS, USA, or LOCAL format depending on the default date/time formats and lengths found in Db2 module DSNHDECP.

The default data format depends on the FORMAT option that is in effect. For example, when FORMAT STANDARD (the default) is in effect, EXTERNAL is the default for the field data type if you do not specify the field data type for a date, time, or timestamp column.

Related topic

UNLOAD-PLUS-options


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*