UTC Time Zone Offset Dropped From XML Timestamps Wehn Updating the XML
(Doc ID 1683711.1)
Last updated on MARCH 10, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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