On exporting a data grid with dates to an Excel instance, the date format is not as expected.
Issue noted on Toad World post: date format problem when exporting to Excel instance
Example: select to_date('6.01.2014 12:00','dd.mm.yyyy hh24:mi') as datum from dual;
The Data grid returns : 06.01.2014 12:00:00
Export to Excel Instance returns: DATUM 06.01.2014 12:00
Request to show the date in numerical form in excel.
WORKAROUND
STATUS
This Idea has been submitted to Development on the Toad for Oracle Idea Pond for consideration in a future release of Toad for Oracle.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy