UTC Time Zone Offset Dropped From XML Timestamps Wehn Updating the XML (Doc ID 1683711.1)

Last updated on FEBRUARY 08, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms