Quick Links
+
Overview
Alphabetic
Date/Time
Multi-Byte
Numeric
Endianness
IRI software products support these date formats -- as well as custom date format masks -- for data transformation, reporting, and test data generation operations:
Date, Time, and TimeStamp Types |
Syntax |
|---|---|
AMERICAN_DATE |
month(name or integer)/day/year |
AMERICAN_TIME |
hour[:minute][:second] xM |
AMERICAN_TIMESTAMP |
month/day/year hour[:minute][:second] xM |
EUROPEAN_DATE |
day.month(name or integer).year |
EUROPEAN_TIME |
hour[.minute][.second] |
EUROPEAN_TIMESTAMP |
day.month.year hour[.minute][.second] |
JAPANESE_DATE |
year-month(name or integer)-day |
JAPANESE_TIME |
hour[:minute][:second] |
JAPANESE_TIMESTAMP |
year-month-day hour[:minute][:second] |
ISO_DATE |
year-month(name of integer)-dat |
ISO_TIME |
hour[.minute][.second] |
ISO_TIMESTAMP |
year-month-day hour[:minute][:second] |
MONTH_DAY |
Jan "<" Feb and "Wed" < "Thu" |
YEAR 2000 Types |
Syntax |
|---|---|
Y2K_ASCII_YR |
2-digit year |
Y2K_ASCII_JULIAN |
5-digit Julian date |
