1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to change date format in rtf

Discussion in 'Oracle Apps Technical' started by jagadekara, Sep 2, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I have trx_date column in my query which is displaying '02-SEP-2014' format.

    It is XMLP report. I need to display '2014-SEP-02' in output. I don't want to chane in Query.

    So how can I do it with RTF?

    I tried like below but now working...

    <?xdofx:to_char(TRX_DATE,'YYYY-MON-DD')?>