We aim to find an Excel format that matches as close as possible to what the date is formatted as in the result set.
Prior to 19.2, Excel exports did not have dated formatted as dates, period.
Are you using 19.2 or 19.4?
Please share a scenario with actual vs expected behavior. A select x from dual query for example...
Overall it is probably better to export date columns as such, but this also means dates before 1901-01-01 appear as -1 in excel. Something to be aware of.(and which i do not see in the 19.4 release notes)
SELECT LEVEL, DATE'1899-12-01' + LEVEL - 1 as day FROM dual CONNECT BY LEVEL <= 62
Sadly when claiming millions of users, *any* such little change (even meant for the better) is likely to aggravate someone, somewhere.
To the OP: you can either apply the wanted format in excel or use an explicit TO_CHAR on the date columns.
It would be in the 19.2 release notes