PowerCenter supports the following format for date, time, and datetime datatypes:
CCYY-MM-DDThh:mm:ss:sss
Use this format or any portion of this format in an XML file. PowerCenter does not support negative dates for datetime format.
Use a date, time, or datetime element in either of the following formats within a session:
CCYY-MM
- or -
CCYY-MM-DD/Thh
The format of the first datetime element in an XML file determines the format of all subsequent values of the element. If the Integration Service reads a value for the same date, time, or datetime element that has a different format, the Integration Service rejects the row.
For example, if the first value of a datetime element is in the following format:
CCYY-MM-DDThh:mm:ss
The Integration Service rejects a row that contains the element in the following format:
CCYY-MM-DD
The XML parser converts the datetime value in the input XML to a value in the local time zone of the machine that hosts the Integration Service. If you enable the option to adjust the clock for daylight saving changes on Windows, the XML parser adds an hour to the datetime value. For consistent datetime value conversions, do not enable the option on Windows to adjust the clock for daylight saving changes.