9.0 Date Export to Excel - Different Format in .xls and .xlsx

[Scott Neville]

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

 

[Marco Kalter]

We're looking into this issue right now.

 

[Scott Neville]

Were you able to duplicate the issue?

 

[Marco Kalter]

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

 

[Scott Neville]

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.

 

[Marco Kalter]

We'll check it out.

 

[bsullivan]

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

select sysdate from dual;

I get the following output:

12/5/2011 2:08:20 PM

When I export that to XLSX, I get the following:

12/5/2011 14:08:20 A12P12

If I right click on that cell and select format, the format is showing as Custom, using the code

m\/d\/yyyy h:mm:ss \AmPm

 

[Marco Kalter]

We'll check it out.

 

[Marco Kalter]

Can you get the windows date time format for me?

 

[jlcox]

I see this also when exporting as xslx.

 

[Marco Kalter]

Could you try again with this version?

plsqldev903.1643.exe

if it still fails, please let me know the windows date and time format.

 

[jlcox]

That version fixes the problem for me.

 

[Marco Kalter]

Okay, thanks for letting me know.

 

[bsullivan]

Looks like this is working for me as well. Thanks!

 

[juanian]

I am seeing the AM/PM problem (A7P7) with 9.0.6.1665 when I use "Copy to Excel" / "Copy all as xls". The other 3 copy to Excel methods work fine.

 

[Marco Kalter]

Can you let me know exactly what goes wrong?

 

[juanian]

(Sorry for the late reply - this wasn't in my Watched Topics)

Dates that are formatted with the 12-hour time don't show the AM (or PM) properly when using "Copy to Excel"/"Copy all as xls" - it appears like A1P1, or A4P4, or A10P10, or ... .

The fix that was made for the "Copy to Excel"/"Copy as xls" needs to be applied to the "Copy to Excel"/"Copy all as xls".

I haven't tried Version 10 yet to see if this is fixed there, but it occurs in 9.0.6.1665.