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?