Date & Time Data Types

 

 

Process Standard and Custom Date Formats

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