My Oracle Support Banner

BI Publisher : How To Transform a Date in Oracle Report To Canonical Format ? (Doc ID 954904.1)

Last updated on DECEMBER 04, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.0.0 to 5.6.3 [Release 5]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 5.0 to 5.6.3


Goal

You are using Bi Publisher and produced a xml data file using Oracle Reports.

To use the format-date function inside the RTF template, the date must be in the following canonical format :

2009-11-04T00:30:00.000-06:00

How to transform a date in Oracle Reports to canonical format ?

Solution

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
Goal
Solution

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