Date & Time Data Types

 

Next Steps
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
Share this page

Request More Information

Live Chat

* indicates a required field.
IRI does NOT share your information.