-
Title
Date format is incorrect after exporting to csv format. -
Description
There seems to be an issue with how it is displaying the date format when the data are exported, which is causing issues with further data manipulation.
Instead of "12/15/2008" being shown and exported, the export gives "2008-12-15 00:00:00" as the date format. In previous 3.1.1 version, there was no difference in date format from the Toad grid and the exported data. -
Cause
This is an issue with export but only an issue if exported in a format other than Excel.
-
Resolution
This is an issue with export but only an issue if exported in a format other than Excel.
WORKAROUND 1:
Set date format for the grid in Toad options. This should export correctly if exporting as Excel.
WORKAROUND 2:
Manually adjust date format after exporting.
STATUS:
Issue fixed in Toad for DB2 4.5. The latest version of Toad for DB2 can be downloaded at http://support.quest.com -
Defect ID
CR 63,051 -
Additional Information
Not a problem in Toad for DB2 3.1 and older.