Siebel Financial Services Connector for IAA-XML Guide > Data Types >

Date and Time Formats

Time is specified at the hub in a character format at the moment, with no validation expected. Siebel highly recommends users follow the ISO8601 standard, which is the proposed standard for dates and times in XML schemas. The ISO8601standard specifies time as follows:

CCYY-MM-DDThh:mm:ss.sssZ

Where CCYY is the year, MM is the month, DD is the day, T is the literal T used as a date-time separator, hh is the hours using a 24 hour clock, mm is minutes, and ss.sss is seconds. The Z indicates that the time is in Coordinated Universal Time (UTC). To indicate a timezone different from UTC follow the time with ±hh:mm to signify the difference from UTC and omit the 'Z'. The followings are examples of valid and equivalent times:

2000-04-06T19:30:40Z signifying GMT

2000-04-06T20:30:40+1:00 signifying CET

2000-04-06T13:30:40-6:00 signifying CT (US)

ISO8601 also specifies the format for time duration. It allows the omissions of parts of the date and time. This can be useful when you are only interested in the underwriting year or the renewal month and year. The following representation is used to achieve this:

PnYnMnDTnHnMnS

An optional preceding '-' (before the P) may be specified to signal a negative duration. For example, P1Y2M3DT10H30M signifies 1year, 2 months, 3 days, 10 hours and 30 minutes; -P10Y means 10 years ago. The specification may be truncated on the right. Time periods can be specified using several combinations of times: the start instant and a duration, the start instant and end instant, or the end instant and a negative duration.

NOTE:  For details, refer to the ISO standard document.