This discussion is archived
1 Reply Latest reply: Jun 13, 2013 1:20 PM by Jeff Smith SQLDev PM RSS

SQL Developer 3.2 - Exporting data with TIMESTAMP datatype

1008686 Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points