Date and Time - JET Software

Date and Time Data Types

Processing of 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:

Date, Time, and Timestamp Types	Syntax
AMERICAN_DATE	month(name or integer)/day/year
AMERICAN_TIME	hour[:minute][:second] AM/PM
AMERICAN_TIMESTAMP	month/day/year hour[:minute][:second] AM/PM
EUROPEAN_DATE	day.month(name or integer).year
EUROPEAN_TIME	hour[.minute][.second]
EUROPEAN_TIMESTAMP	day.month.year hour[.minute][.second]
JAPANESE_DATE_FORMAT	year-month(name or integer)-day
JAPANESE_TIME	hour:minute:second
JAPANESE_TIMESTAMP	YYYY-MM-DD hour:minute:second
ISO_DATE	year-month(integer name)-day
ISO_TIME	hour[.minute][.second]
ISO_TIMESTAMP	YYYY-MM-DD hour:minute:second
Month/Day	January < February and Wednesday < Thursday„

Year 2000 types	Syntax
Y2K_ASCII_YEAR	2-digit year
Y2K_ASCII_JULIAN	5-digit Julian date

IRI Software products support these date formats - as well as custom date format masks - for data transformation, reporting, and test data generation:

Date, Time, and Timestamp Types	Syntax
AMERICAN_DATE	month(name or integer)/day/year
AMERICAN_TIME	hour[:minute][:second] AM/PM
AMERICAN_TIMESTAMP	month/day/year hour[:minute][:second] AM/PM
EUROPEAN_DATE	day.month(name or integer).year
EUROPEAN_TIME	hour[.minute][.second]
EUROPEAN_TIMESTAMP	day.month.year hour[.minute][.second]
JAPANESE_DATE_FORMAT	year-month(name or integer)-day
JAPANESE_TIME	hour:minute:second
JAPANESE_TIMESTAMP	YYYY-MM-DD hour:minute:second
ISO_DATE	year-month(integer name)-day
ISO_TIME	hour[.minute][.second]
ISO_TIMESTAMP	YYYY-MM-DD hour:minute:second
Month/Day	January < February and Wednesday < Thursday„

Year 2000 types	Syntax
Y2K_ASCII_YEAR	2-digit year
Y2K_ASCII_JULIAN	5-digit Julian date