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!

SQL Developer 3.2 - Exporting data with TIMESTAMP datatype

1008686Jun 13 2013 — edited Jun 13 2013

Hi,

We have users that are attempting to export data with the Timestamp format to Excel (xls format) using SQL Developer 3.2. When attempting to sort the Timestamp in either asc or desc order, Excel is having issues sorting correctly. I suggested that the user just do all the sorting within their SQL Developer session but they require the ability to slice and dice in Excel.

This is definitely not an issue with Excel as the users have previously exported Timestamp data from Toad and been able to sort without issue. Any thoughts as to what might resolve this issue?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2013

Added on Jun 13 2013

#excel, #sql-developer

1 comment

856 views