User used Toad for DB2 v 5.0 to export data to excel file. Toad shown correct date format mm/dd/yyyy hh:mm:ss AM/PM, however, Excel shown different date format.
An example: Excel displayed the results as 2012-05-01-09.38.45.873000, however when looking at in in TOAD qbe it is displayed correctly as 05/0102012 09:38:45 AM.
How does user export the results as they are seen in the Toad Query Builder to the Excel file so the date&time fields are displayed correctly ?
Waiting for a fix with CR100842 on a future release of Toad for DB2.