XMLQUERY FN:CURRENT-DATETIME() DOES NOT ALWAYS RETURN CORRECT TIMEZONE
(Doc ID 2114119.1)
Last updated on MARCH 28, 2019
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2 to 12.1]
Information in this document applies to any platform.
The function to get current date/time in XMLQUERY is "fn:current-dateTime()". In a lot of cases, the timezone information is lost in the returned date/time. The most basic example of it is when there is a function call anywhere in the xmlquery function even when it has nothing to do with the date.
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