1

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’)?>, but the output is 2017-09-18

Jacob
  • 14,463
  • 65
  • 207
  • 320

1 Answers1

1

Did you try using the to_date function ? Its documented here.

Ranjith R
  • 1,571
  • 1
  • 11
  • 11