Parsing Date and Datetime Strings
In XML documents parsed by the XML Parser activity, datetime values are read in according to the ISO-8601 standard, as described in the XML Schema specification. For example, the value:
2002-02-10T14:55:31.112-08:00
is 55 minutes, 31 seconds, and 112 milliseconds after 2PM on February 10th, 2002 in a time zone that is 8 hours, 0 minutes behind UTC.
If no time zone field is present, the value is interpreted in the time zone of the machine that is performing the parsing. This can lead to complications if you are processing XML from different time zones, so you are encouraged to always use time zones.