5 1 4 Date and Time Formats

LANSA Integrator

previous page next page

5.1.4 Date and Time Formats

The International Standard for the representation of dates and times is ISO8601.

For unambiguous representation of dates and times the following formats have been chosen. The date separator - (dash) can be replaced with a / (slash). The time element separator T can be a blank. The time zone value of hh:mm can be hhmm or hh, but the + or - is mandatory. If no time zone is present then a hierarchy of time zones will be used, the time zone determined by the service or +00:00.

A program can pass a date value to the service using different formats. If the program field is numeric then use the all numbers format. If program field is an alphanumeric then use the string format or numeric format.

Possible program field values:

YYYYMMDD [TZD]

YYYYMMDDHHMMSS [TZD]

YYYY-MM-DD [TZD]

YYYY/MM/DD [TZD]

YYYY-MM-DD HH:MM:SS [TZD]

YYYY-MM-DDTHH:MM:SS [TZD]

YYYY-MM-DDTHH:MM:SS.SSSSSSSSS [TZD]

YYYY	Four digit year (1000-9999).
MM	Two digit month (01-12).
DD	Two digit day (01-31).
HH	Two digit hour (00-23). Default. 00.
MM	Two digit minute (00-59). Default 00.
SS	Two digit second (00-59). Default 00.
SSSSSSSSS	One to nine digits representing a decimal fraction of a second. Default. 000000000.
TZD	Time zone designator (Z or +hh:mm or -hh:mm) Z means GMT or +00:00. Default. +00:00.

Example program field date values:

20040331

20040331+10

20040331150000

20040331150000Z

20040331150000+10

20040331150000+1000

20040331150000+10:00

2004-03-31

2004-03-31+10

2004-03-31 15:00:00

2004-03-31 15:00:00Z

2004-03-31 15:00:00+10

2004-03-31 15:00:00+1000

2004-03-31 15:00:00+10:00

2004-03-31 15:00:00.000+10

2004-03-31T15:00:00.000+10:00

To convert a date time into a string representation the following case-sensitive date format patterns can be used.

yy	2 digit year	00-99.
yyyy	4 digit year	1000-9999.
MM	Month in year	01-12.
MMM	Month in year	Jan-Dec (Locale dependent).
MMMM	Month in year	January-December (Locale dependent).
dd	Day in month	01-31.
HH	Hour in day	00-23.
mm	Minute in hour	00-59.
ss	Second in minute	00-59.
SSS	Millisecond	000.
SSSSSSSSS	Nanosecond	000000000.
z	TimeZone	GMT+00:00.
Z	TimeZone	+0000.
ZZ	TimeZone	+00:00.
AM/PM	AM PM Marker	AM or PM (Locale dependant).
hh	Hour in AM/PM	1-12.
EE	Day in week	1-7.
EEE	Day in week	Sun-Sat (Locale dependant).
EEEE	Day in week	Sunday-Saturday (Locale dependant).

Example date format patterns:

dd-MM-yyyy

dd-MM-yyyy HH:mm:ss

dd-MM-yyyy HH:mm:ss Z

previous page start next page