My Oracle Support Banner

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 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

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:

 

 

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.