Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Bug? - Export to Excel: date formatted as text

Danilo PiazzalungaJul 16 2018 — edited Jul 18 2018

Hi,

when exporting query results to Excel (2003+, .xlsx format), DATE and TIMESTAMP columns are not formatted as dates; instead, they are formatted as text.

Tested versions:

  • 18.1
  • 18.2

Steps to reproduce:

  1. Start up SQL Developer using the default settings
  2. Run some query on a table or view containing DATEs and TIMESTAMPs. For example, the ALL_OBJECTS data dictionary view:
    • select * from all_objects;
  3. Export query results to an Excel (2003+) .xlsx file
  4. Open the resulting file

Expected result:

  • CREATED and TIMESTAMP columns contain numbers formatted as dates. For example:
    • CREATED should contain 42746, formatted as a date (11-JAN-17)
    • TIMESTAMP should contain 42746.5327893519 formatted as a date (2017-01-11:12:47:13)

Actual result:

  • CREATED and TIMESTAMP columns contain text. For example:
    • CREATED = "11-JAN-17"
    • TIMESTAMP = "2017-01-11:12:47:13"
This post has been answered by Marwim on Jul 17 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 14 2018
Added on Jul 16 2018
3 comments
1,096 views