3 Replies Latest reply on Jan 20, 2020 11:19 AM by thatJeffSmith-Oracle

    SQL Developer Excel Export Date Format not right

    jabraga68

      since Oracle SQL developer 19.2 when exporting data to excel the date format does not match the NLS formatting in SQL Developer or the format in Windows.

       

      I have set SQL Dev to be "YYYY-MM-DD HH24:MI:SS" and Windows is set to "YYYY-MM-DD" but when excel is exported the format is MM-DD-YYYY.  However exporting to Text or delimited honors the NLS parameters.

       

      I know my excel is correct as if enter a date it must be in YYYY-MM-DD format as it should.

       

      This used to work until verson 19.2

       

      I have verified this issue on Windows 7 / 2008 / 10

       

      I have also looked at the Style.xml that is created for the Excel doc and it clearly shows there M-D-YYYY as the format.  Where is this coming from?