Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Parameter Date Formatting
Summary
Parameter Date Formatting
Content
In XML Publisher template, how can I format the date parameter to DD-Mon-YYYY format?
<?param@begin: p_start_date?>Start Date - <?xdofx:substr($p_start_date,1,4) || '-' || substr($p_start_date, 6,2) || '-' || substr($p_start_date, 9,2)?>
With the above format, my output is 2017-09-18, expected output is 18-May-2017
I have even tried with <? xdofx:p_start_date('DD-Mon-YYYY’)?> and <?xdofx:to_char($p_start_date,'DD-MON-YYY')?> but the output is 2017-09-18
Answers
-
If p_start_date is in canonical date format then you can use to_date in rtf
example if p_start_date is '2017-05-31T11:37:01.262+00:00' then you can use <?xdofx:to_date(p_start_date,'dd-MMM-yyyy')?>
0 -
No I mean was value appearing for p_start_date in xml....can you paste sample value for p_start_date
0 -
What is the date format of p_start_date in XML file?
0 -
<?xdofx:to_date(SYSDATE,'dd-mon-yyyy')?> ----if date is in canonical format.
Also please mention how the p_start_date is appearing in xml file.i.e formart of p_start_date
0 -
Hello,
I have defined p_start_date as below, I have not formatted it.
<parameter name="p_start_date" dataType = "date"></parameter>
Do I need to format?
0