Supported DATE, TIME, and TIMESTAMP formats
The tables in this topic list input date, time, and timestamp formats that UNLOAD PLUS supports in addition to the internal Db2 date, time, and timestamp formats.
These formats support the conversion of CHAR, INTEGER, and DECIMAL data types to DATE-format, TIMESTAMP-format, and TIME-format EXTERNAL formats.
When using DIRECT NO, DATE-format, TIMESTAMP-format, or TIME-format formats requires extra consideration due to the various ways in which the data is returned from Db2. Often, the same DATE-format, TIMESTAMP-format, or TIME-format formats are not appropriate when using DIRECT YES versus DIRECT NO.
The following table describes the Date format:
Format number Char/Int/Dec | Nondelimited format | Format number Char | Delimited format 1 |
|---|---|---|---|
1 | MMDDYY | D1 | MM/DD/YY |
2 | YYMMDD | D2 | YY/MM/DD |
3 | YYDDD | D3 | YY/DDD |
4 | YYWWD | D4 | YY/WW/D |
5 | DDMMYY | D5 | DD/MM/YY |
6 | DDDDD | ||
1E | MMDDYYYY | D1E | MM/DD/YYYY |
2E | YYYYMMDD | D2E | YYYY/MM/DD |
3E | YYYYDDD | D3E | YYYY/DDD |
4E | YYYYWWD | D4E | YYYY/WW/D |
5E | DDMMYYYY | D5E | DD/MM/YYYY |
1 ‘/’ can be any character.
The following tables describes the Timestamp formats:
Format number | Nondelimited format 1 |
|---|---|
1 | YYMMDDHHMMSS |
2 | YYMMDDHHMMSSNNNNNN 2 |
3 | Store clock 8-byte binary |
1E | YYYYMMDDHHMMSS |
2E | YYYYMMDDHHMMSSNNNNNN 2 |
1 Formats are CHAR only except 3.
2 The number of microseconds (N) can be from 0 through 12.
The following table describes the Time format: