Date fields are being translated to numeric format on the Excel Export function using Data Grid | Save As option in Toad for Oracle 9.7. By executing 'select sysdate from dual' the date column will appear correctly within Toad. The issue appears after exporting the date column to Excel; it will appear as a number instead of as date format.
WORKAROUND:
1. Right click on the date column output from the Data Grid | select Save As | select 'Excel Instance' for the Export Format.
2. After exporting the date column from Toad, right-click on the cell within the Excel application and select the Format option to format cells as date.
STATUS:
Issue fixed in version 9.7.2.5.
The latest version of Toad for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center