2 Replies Latest reply on Dec 5, 2013 10:28 PM by Mike Kutz

    Date format issue while displaying on report




      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.