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 ?
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center