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
errabellirammohanrao
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,
Ram
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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-MM-DDThh:mm:ss+HH:MM
where
• 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
Time
An example of this construction is:
2005-01-01T09:30:10-07:00
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.

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


Current Time: Sat Dec 03 05:43:21 CST 2016

Total time taken to generate the page: 0.07250 seconds