Date Format - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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.

Note: You must use valid month/day combinations for the Japanese date format. If the month/day is invalid, the output data is blanked out.