XML Representation of Date Values

Previous Next

In general, the ISO 8601 standard is used for representing date values within XML. A reference of a document that describes the ISO 8601 standard for dates can be found at:

http://www.iso.ch/

In the area of exporting and importing XML documents, USoft supports the following date formats.

Date Characters

Here is an explanation of the characters used to describe IO formats.

[C] represents a digit used in the thousands and hundreds components (the "century" component) of the time element "year".

[Y] represents a digit used in the tens and units components of the time element "year".

[M] represents a digit used in the time element "month".

[D] represents a digit used in the time element "day".

[w] represents a digit used in the time element "week".

[h] represents a digit used in the time element "hour".

[m] represents a digit used in the time element "minute".

[s] represents a digit used in the time element "second".

[n] represents a digit(s), constituting a positive integer.

XML Export IO Format

When exporting date values to an XML document, this IO format is used:

CCYY-MM-DDThh:mm:ss

XML Import IO Formats

When importing an XML document, these date value IO formats are recognized:

Format

Example

Description

YYMMDD

850412

A specific date in the current century

YY-MM-DD

85-04-12

Extended format

-YYMM

-8504

A specific year and month in the current century

-YY-MM

-85-04

Extended format

-YY

-85

A specific year in the current century

--MMDD

--0412

A specific day of a month

--MM-DD

--04-12

Extended format

--MM

--04

A specific month

---DD

---12

A specific day

CCYYMMDD

19850412

 

CCYY-MM-DD

1985-04-12

 

CCYYMM

198504

 

CCYY-MM

1985-04

 

CCYY

1985

 

YYWwwD

85W155

Year, week and day in the current century

YY-Www-D

85-W15-5

Extended format

YYWww

85W15

Year and week only in the current century

YY-Www

85-W15

Extended format

-YwwwD

-5W155

Year of the current decade, week and day only

-Y-Www-D

-5W15-5

extended format

-WwwD

-W155

Week and day only of the current year

-Www-D

-W15-5

Extended format

-Www

-W15

Week only of the current year

-W-D

-W-5

Day only of the current week

---D

---5

Day only of any week

-mm:ss

-20:50

A specific minute and second of the hour (Extended format)

CCYYMMDDThhmmss

19850412T101530

Calendar date and local time of the day

CCYYMMDDThhmm

19850412T1015

 

CCYYMMDDThh

19850412T10

 

CCYY-MM-DDThh:mm:ss

1985-04-12T10:15:30

Extended format

CCYY-MM-DDThh:mm

1985-04-12T10:15

 

CCYY-MM-DDThh

1985-04-12T10

 

CCYYDDDThhmmss

1985102T235030

Ordinal date and local time of the day

CCYYDDDThhmm

1985102T2350

 

CCYYDDDThh

1985102T23

 

CCYY-DDD-Thh:mm:ss

1985-102T23:50:30

Extended format

CCYY-DDDThh:mm

1985-102T23:50

 

CCYY-DDDThh

1985-102T23

 

CCYYWwwDThhmmss

1985W155T235030

Date indentified by calendar week and day numbers and local time of the day

CCYYWwwDThhmm

1985W155T2350

 

CCYYWwwDThh

1985W155T23

 

CCYY-Www-DThh:mm:ss

1985-W15-5T23:50:30

Extended format

CCYY-Www-DThh:mm

1985-W15-5T23:50

 

CCYY-Www-DThh

1985-W15-5T23

 

Unsupported Date Formats

The following data value IO formats are not supported:

Format

Example

Description

hh,h

23,3

A specific hour of the day and decimal fraction of the hour

-mm,m

-20,9

A specific minute of the hour and a decimal fraction of the minute

-mmss,s

-2050,5

A specific minute and second of the hour and a decimal fraction of the second

-mm:ss.s

-20:50,5

Extended format

--ss,s

--50,5

A specific second of the minute and a decimal fraction of the second

HhmmssZ

232030Z

Time with Coordinated Universal Time (UTC)

hh:mm:ssZ

23:20:30Z

Extended format

HhmmZ

2320Z

 

hh:mmZ

23:20Z

 

HhZ

23Z

 

Midnight Time

There are two representations of midnight time:

00:00:00 000000

24:00:00 240000

 

The Rules Engine only supports '00:00:00' when exporting and importing XML documents.

Period Of Time

Period of time is a duration with a start time and an end time. The Rules Engine does not support the period of time IO format.