2 Replies Latest reply: Dec 5, 2013 4:28 PM by Mike Kutz RSS

    Date format issue while displaying on report

    950123

      Hi,

       

      While displaying report in APEX, the value stored in DB is 12/06/2013 i.e. (MM/DD/YYYY) but while displaying on the report, it shows 13-DEC-06.

      When I download this report in Excel, the value being take is 13th Dec 2006 which of course is wrong.

       

      I have simply taken the column in the query as I have done it many times in other reports as well. Its being reflected fine for the other reports without any conversions.

      How can I change the format to show 06-DEC-2013 in the erroneous report?

       

      I've even tried using the to_char option  OR changing the "Number / Date Format" in the Column Definition but to no success.

      Thanks.