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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center