Home » Applications » Oracle Fusion Apps & E-Business Suite » xml Publisher report , Date format
icon14.gif  xml Publisher report , Date format [message #233161] Wed, 25 April 2007 01:14 Go to next message
Messages: 1
Registered: August 2006
Junior Member
Hi all,

I have an XML publisher Report, with date format, dd-mon-yy.

I want to change the date format to dd-mm-yy.

Where i have to change? whether can i change it in RTF level or i have to change in report query level?

Please reply me, if anybody knows.

Thanks in advance,
Re: xml Publisher report , Date format [message #233289 is a reply to message #233161] Wed, 25 April 2007 09:37 Go to previous message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Data Source Requirements
To use the Microsoft format mask or the Oracle format mask, the date from the XML
data source must be in canonical format. This format is:
• YYYY is the year
• MM is the month
• DD is the day
• T is the separator between the date and time component
• hh is the hour in 24-hour format
• mm is the minutes
• ss is the seconds
• +HH:MM is the time zone offset from Universal Time (UTC), or Greenwich Mean
An example of this construction is:
The data after the "T" is optional, therefore the following date: 2005-01-01 can be
formatted using either date formatting option. Note that if you do not include the time
zone offset, the time will be formatted to the UTC time.
In xml file, if you have the date in above format then you can change it in rtf using format-date function.

Previous Topic: ATO ITEM
Next Topic: userexits
Goto Forum:

Current Time: Sat Jul 22 22:17:01 CDT 2017

Total time taken to generate the page: 0.11342 seconds