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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy