Return
-
Title
Date Format on Export to Excel Instance partially incorrect -
Description
On exporting a data grid with dates to an Excel instance, the date format is not as expected.
Issue noted on Toad World post: date format problem when exporting to Excel instance
Example: select to_date('6.01.2014 12:00','dd.mm.yyyy hh24:mi') as datum from dual;
The Data grid returns : 06.01.2014 12:00:00
Export to Excel Instance returns: DATUM 06.01.2014 12:00
Request to show the date in numerical form in excel.
-
Resolution
WORKAROUND
- Use the export to excel file option.
- Use the custom format setting in excel.
- Create an Excel file with the correct format.
STATUS
This Idea has been submitted to Development on the Toad for Oracle Idea Pond for consideration in a future release of Toad for Oracle.
Leave a Comment
- Featured Content
- What's new in v13?
- Which Installer do I download?
- Search KBs from within Toad
- Common Connection Issues
- How to find the license number
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- Contact Us
- Technical Support
- View All
- Product(s):
-
Toad for Oracle
12.6
- Topic(s):
- Configuration
- Article History:
- Created on: 2/3/2015
Last Update on: 2/3/2015
- Author:
- Eoghan Cotter
- Search All Articles
-