XML Publisher - Format Field Date - Bi Publisher

[dr_gori]

After attempting various forms, I was able to format a field date in the XML Publisher as follows:

The input field was coming with this format:

Select all

24-NOV-2010 19:08:23

Then: I clicked twice in the field, properties, help text.
Ali, I put the following code in the "Status Bar" tab

Select all

<?xdofx:substr(CREATION_DATE,1,11)?>

This way it converts the text that comes to that default date.


Then: does anyone know a better way to format the dates?
I wanted to transform on 24/11/2010

.

[LordElfo]

Opa guy tries this here oh.

Select all

<?xdofx: 
(substr(CREATION_DATE,9,2)||'/'||decode(substr(CREATION_DATE,6,2)||'/'|substr(CREATION_DATE,1,4))?>

[dr_gori]

My problem is the mês field, which is in mon-format.

24- nov -2010 19:08:23

I have already tried everything to format this month, but xdofx seems that it does not accept much other than substr, nvl and decode ...

[LordElfo]

Hmmm then the way is to use the same decode ....
01 - 'Jan'
02 - 'fev'

[dr_gori]

That is it!

And to make matters worse, you can be in Portuguese or English :-

[alexrsilva]

See if this [url=http://blogs.oracle.com/xmlpublisher/20 ... tions.html]link meets you

[dr_gori]

Hi Alexrsilva

In fact, this link works for when the formatting is coming in the YYYY-MM-DD standard.

As my date is coming in the following format: dd-MON-yyyy hh24:mi:ss

Then I managed to wear Decode even for the months in English and Portuguese:

Select all

<?xdofx:substr(CREATION_DATE,1,2)?>/<?xdofx:decode(substr(CREATION_DATE,4,3), 
'JAN','01/','FEB','02/','FEV','02/','MAR','03/','APR','04/','ABR','04/', 
'MAY','05/','MAI','05/','JUN','06/','JUL','08/','AUG','08/','AGO','08/', 
'SEP','09/','SET','09/','OCT','10/','OUT','10/','NOV','11/','DEC','12/','DEZ','12/' )?><?xdofx:substr(CREATION_DATE,8,4)?>

: -The solved