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