When exporting data from the same column in the Toad result Data Grid into an Excel instance, some dates in the Excel cells are being shown in the wrong format. The two dates shown in Toad using the format:
DD/MM/YYYY
12/02/2008
20/02/2008
when exported to Excel the first one is in MM/DD/YYYY the second entry is correct.
02/12/2008
20/02/2008
WORKAROUND:
Use the Export to an Excel File output when exporting from the Data Grid.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center