Date format is a type of data which may contain only valid dates. The following table contains a list of valid date formats.
|
Type |
Data Format |
|---|---|
|
ASCII AMERICAN |
MM(/)DD(/)YYYY. 8 or 10 bytes. Valid delimiters: / - , |
|
ASCII EUROPEAN |
DD(/)MM(/)YYYY. 8 or 10 bytes. Valid delimiters: / - , |
|
ASCII JULIAN |
(YY)YY(/-)DDD. 5, 7, or 8 bytes. Valid delimiters: / - , |
|
ASCII LONG JULIAN |
YYYY(/-)DDD. 7 or 8 bytes. Valid delimiters: / - , |
|
ASCII YEAR FIRST |
YYYY(/)MM(/)DD. 8 or 10 bytes. Valid delimiters: / - , |
| UCS2 AMERICAN | MM(/)DD(/)YYYY. 16 or 20 bytes. Valid delimiters: / - , |
| UCS2 EUROPEAN | DD(/)MM(/)YYYY. 16 or 20 bytes. Valid delimiters: / - , |
| UCS2 JULIAN | (YY)YY(/-)DDD. 10, 14, or 16 bytes. Valid delimiters: / - , |
| UCS2 LONG JULIAN | YYYY(/-)DDD. 14 or 16 bytes. Valid delimiters: / - , |
| UCS2 YEAR FIRST | YYYY(/)MM(/)DD. 16 or 20 bytes. Valid delimiters: / - , |
|
EBCDIC AMERICAN |
MM(/)DD(/)YYYY. 8 or 10 bytes. Valid delimiters: / - , |
|
EBCDIC EUROPEAN |
DD(/)MM(/)YYYY. 8 or 10 bytes. Valid delimiters: / - , |
|
EBCDIC JULIAN |
(YY)YY(/-)DDD. 5, 7, or 8 bytes. Valid delimiters: / - , |
|
EBCDIC LONG JULIAN |
YYYY(/-)DDD. 7 or 8 bytes. Valid delimiters: / - , |
|
EBCDIC YEAR FIRST |
YYYY(/)MM(/)DD. 8 or 10 bytes. Valid delimiters: / - , |
|
PACKED AMERICAN |
0MMDDYYYY. 5 bytes. |
|
PACKED EUROPEAN |
0DDMMYYYY. 5 bytes. |
|
PACKED JULIAN |
(YY)YYDDD. 3 or 4 bytes. |
|
PACKED LONG JULIAN |
YYYYDDD. 4 bytes. |
|
PACKED YEAR FIRST |
0YYYYMMDD. 5 bytes. |
|
UNSIGNED PACKED AMERICAN |
MMDDYYYY. 4 bytes. |
|
UNSIGNED PACKED EUROPEAN |
DDMMYYYY. 4 bytes. |
|
UNSIGNED PACKED JULIAN |
0(YY)YYDDD. 3 or 4 bytes. |
|
UNSIGNED PACKED LONG JULIAN |
0YYYYDDD. 4 bytes. |
|
UNSIGNED PACKED YEAR FIRST |
YYYYMMDD. 4 bytes. |
|
SJIS IMPERIAL DATE |
Japanese date format with imperial calendar. CP932 or Shift-JIS encoding only. Example: 昭和30年1月1日 |
|
SJIS JAPANESE DATE
|
Japanese date format with Gregorian calendar. CP932 or Shift-JIS encoding only. Example: 1997年1月1日 |
|
ASCII ROMAJI IMPERIAL DATE
|
Japanese date format with shortened imperial year. ASCII encoding only. Example: S35-1-1 |
|
UCS2 IMPERIAL DATE |
Japanese date format with imperial calendar. UCS2. |
|
UCS2 JAPANESE DATE |
Japanese date format with Gregorian calendar. UCS2. |
|
UCS2 ROMAJI IMPERIAL DATE |
Japanese date format with shortened imperial year. UCS2. |