UTC Time Zone Offset Dropped From XML Timestamps Wehn Updating the XML
(Doc ID 1683711.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document