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:
Steps to reproduce:
- Start up SQL Developer using the default settings
- Run some query on a table or view containing DATEs and TIMESTAMPs. For example, the ALL_OBJECTS data dictionary view:
- Export query results to an Excel (2003+) .xlsx file
- 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"