+-DATE--EXTERNAL--+---------------------+-------------------+
   |                 '-(-+-length------+-)-'                   |
   |                     '-date-format-'                       |
   +-TIME--EXTERNAL--+---------------------+-------------------+
   |                 '-(-+-length------+-)-'                   |
   |                     '-time-format-'                       |
   +-TIMESTAMP--EXTERNAL--+--------------------------+---------+
   |                      '-(-+-length-----------+-)-'         |
   |                          '-timestamp-format-'             |

DATE EXTERNAL
Specifies a character string representation of a date.  You can specify a length or a specific date format. 
(length) The length, if unspecified, is the specified length on the LOCAL DATA LENGTH installation option, or, if none was provided, the default is 10 bytes. If you specify a length, it must be within the range of 8 - 254 bytes.
If a date format is not specified, dates can be in any of the following formats. You can omit leading zeros for month and day. You can include trailing blanks, but no leading blanks are allowed.

    
dd.mm.yyyy
    
mm/dd/yyyy
    
yyyy-mm-dd
    
Any local format that was defined when DB2 was installed
date-format The format of the date representation, as shown in the following table. Values for date-format table
         date-format value   Format                     Length
         -------------------------------------------------------
         DATE_A              mm-dd-yyyy (1)             10 bytes
         DATE_B              mm-dd-yy (1,2)              8 bytes
         DATE_C              yyyy-mm-dd (1)             10 bytes
         DATE_D              yy-mm-dd (1,2)              8 bytes
         DATE_E              dd-mm-yyyy (1)             10 bytes
         DATE_F              dd-mm-yy (1,2)              8 bytes
         DATE_G              yyyy-ddd (1)                8 bytes
         DATE_H              yy-ddd (1,2)                6 bytes
         DATE_I              mmddyyyy                    8 bytes
         DATE_J              mmddyy (2)                  6 bytes
         DATE_K              yyyymmdd                    8 bytes
         DATE_L              yymmdd (2)                  6 bytes
         DATE_M              ddmmyyyy                    8 bytes
         DATE_N              ddmmyy (2)                  6 bytes
         DATE_O              yyyyddd                     7 bytes
         DATE_P              yyddd (2)                   5 bytes
If a date format is specified for a field that is used in a field specification, the field specification must also use the specified date format.
Notes: 

    
If the format includes separators, the separator can be any single-byte character that can be converted to a single-byte EBCDIC  character.
 
    
If a two-digit year is specified, it is expanded to a four-digit year. If the two-digit year is less than the sum of the two-digit current year plus 50, then the current century is used in the four-digit year. For example, assume that the current year is 2017. If the two-digit year is 67, 1967 is used.
However, if the two-digit year is 66, 2066 is used.

TIME EXTERNAL
Specifies a character string representation of a time. You can specify a length or a specific time format. 
(length) The length, if unspecified, is the specified length on the LOCAL TIME LENGTH installation option, or, if none was provided, the default is 8 bytes. If you specify a length, it must be within the range of 4 - 254 bytes.
If a format is not specified, times can be in any of the following formats 

    
hh.mm.ss
    
hh:mm AM
    
hh:mm PM
    
hh:mm:ss
    
Any local format that was defined when DB2 was installed
You can omit the mm portion of the hh:mm AM and hh:mm PM formats if mm is equal to 00. For example, 5 PM is a valid time, and can be used instead of 5:00 PM.

(time-format) The specific format of the time representation, as shown in the following table. Values for time-format table
         time-format value   Format                      Length
         -------------------------------------------------------
         TIME_A              hh.mm.ss (1)                8 bytes
         TIME_B              hh.mm (1)                   5 bytes
         TIME_C              hh.mm AM or
                             hh.mm PM (1)                8 bytes
         TIME_D              hhmmss                      6 bytes
         TIME_E              hhmm                        4 bytes

If a time format is specified for a field that is used in a field specification, the field specification must also use the specified time format.
Notes:

    
If the format includes separators, the separator can be any single-byte character that can be converted to a single-byte EBCDIC character./li>

TIMESTAMP EXTERNAL
Specifies a character string representation of a time. You can specify a length or a specific timestamp format.

(length) The default for length is 26 bytes. If you specify a length, it must be within the range of 19 - 32 bytes. If a timestamp format is not specified, timestamps can be in any of the following formats. nnnnnn represents the number of microseconds, and can be 0 - 12 digits. You can omit leading zeros from the month, day, or hour parts of the timestamp; you can omit trailing zeros from the microseconds part of the timestamp.  

    
yyyy-mm-dd-hh.mm.ss
    
yyyy-mm-dd-hh.mm.ss.nnnnnn
    
yyyy-mm-dd hh:mm:ss.nnnnnn

(timestamp-format) The format of the timestamp representation, as shown in the following table. Values for timestamp-format table
         timestamp-format val Format                      Length
         -------------------------------------------------------
         TIMESTAMP_A       yyyy-mm-dd-hh.mm.ss (1)      19 bytes
         TIMESTAMP_B       yyyy-mm-dd-hh.mm.ss.nnnnnn(1)26 bytes
         TIMESTAMP_C       yyyymmddhhmmss               14 bytes
         TIMESTAMP_D       yymmddhhmmss (2)             12 bytes
         TIMESTAMP_E       yyyymmddhhmmssnnnnnn         20 bytes
         TIMESTAMP_F       yymmddhhmmssnnnnnn (2)       18 bytes

If a timestamp format is specified for a field that is used in a field specification, the field specification must also use the specified timestamp format.

Notes:

    
If the format includes separators, the separator can be any single-byte character that can be converted to a single-byte EBCDIC character.
    
If a two-digit year is specified, it is expanded to a four-digit year. If the two-digit year is less than the sum of the two-digit current year plus 50, then the current century is used in the four-digit year. For example, assume that the current year is 2017. If the two-digit year is 67, 1967 is used.  However, if the two-digit year is 66, 2066 is used.