UTC Time Zone Offset Dropped From XML Timestamps Wehn Updating the XML
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2 to 12.1]
Information in this document applies to any platform.
An XML timestamp (xs:dateTime) with a UTC time zone offset is rewritten by the database without a time zone offset when any modification is made to the XML containing the timestamp.
This makes the timestamp inaccurate.
For instance, when the XML is read from the database the date is interpreted by the client as being in its local time zone, which is wrong.
This example code shows the behavior:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms