When I export from PL/SQL Developer to a .xls file, the date format is m/d/yyyy. When I export to .xlsx the format is dd-mm-yyyy. My date format in PL/SQL Preferences (NLS Options) is M/d/yyyy. I would expect the same format to be used whether exporting to .xls or .xlsx, preferrably respecting my date choice in the PL/SQL Preferences. It is inconvenient to have to select and reformat all dates once then have been exported to a .xlsx file. My other option is to export to .xls and then do a Save As .xlsx. This is a workaround, but also inconvenient when I forget to change format.
- Scott

We're looking into this issue right now.

Were you able to duplicate the issue?

Yes. The issue is fixed for the upcoming 9.0.1 patch release. You can download a pre-release here.

I am running 9.0.1.1613 now and when I export dates to Excel (xlsx) they come out in the format 2/1/2008 9:21:41 A2P2 instead of 2/1/2008 9:21:41 AM. The latter is how dates appear when I export to the older .xls file type.

We'll check it out.

I am running 9.0.3.1641 and I'm still seeing the same issues with exporting to XLSX, where the time format is incorrect.

In the PL/SQL Developer Preferences screen, I'm snowing that for both Date & Time, I have selected 'Windows format'. When I run
[quote]select sysdate from dual;[/quote] I get the following output:
[quote]12/5/2011 2:08:20 PM[/quote]

When I export that to XLSX, I get the following:
[quote]12/5/2011 14:08:20 A12P12[/quote]

If I right click on that cell and select format, the format is showing as Custom, using the code
[quote] m\/d\/yyyy h:mm:ss \AmPm [/quote]

We'll check it out.

Can you get the windows date time format for me?

I see this also when exporting as xslx.