Additional date, time, or timestamp field considerations
This topic describes additional considerations for date, time, and timestamp fields.
A date, time, or timestamp EXTERNAL field produces a character representation of the date, time, or timestamp value, producing an 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
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*