Date Format - trillium_discovery - trillium_quality

Date Format - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type

Software

Portfolio

Verify

Product family

Trillium

Product

Trillium > Trillium Discovery

Trillium > Trillium Quality

Version

17.1

Language

English

Product name

Trillium Quality and Discovery

Title

Trillium Control Center

Topic type

Overview

Administration

Configuration

Installation

Reference

How Do I

First publish date

2008

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.