in Toad for Oracle 188.8.131.52 I execute this query:
select to_date(‘31.03.2013’,‘dd.mm.yyyy’) date_value from dual
In data grid I get date_value: 31.3.2013.
Then I go to “Export Dataset” and choose export format “Excel instance”. I uncheck all the checkboxes, press OK and get a new sheet in my currently open Excel 2010 file (xlsx). The problem is that my date_value is now formatted like this: 31-march-2013
This format does not correspond to any date formats that I have set in my windows control panel. Excel treats it as a string, not as a date, and I can’t do any date operations on this value in excel. I would like to get a date value in excel: 31.3.2013
I’ve also tried exporting it to an older version of Excel file (xls). I’ve tried changing date format in windows control panel. Nothing helped.
This used to work fine in Toad 10.
As far as I can see there is no option in Toad to set the date format when exporting to Excel instance. When exporting to Excel File there is an option to set the date format, and it works fine, but exporting to a File is not good for me for some other reasons (strings which contain only numbers are are converted to numbers in Excel and I don’t want that to happen).
Is there a way to get the correct date format in Excel instance export in Toad 11.6?
Any help is appreciated.