Sorting in output-pane of SQL-Window wrong if datatype is timestamp

[LutzB]

Hi,
this is about the output-pane of an SQL-Window.
In order to sort the output you can click on the small square beside the column-name.
For columns of type INTEGER, DATE and VARCHAR it works fine, but if the column-type is "TIMESTAMP" the sort-order is wrong.
E.g. sorting ascending delivers:
13.01.10 15:49:11,371337000
15.01.10 08:03:17,969306000
15.12.09 10:36:11,475878000
15.12.09 12:37:14,911886000
15.12.09 12:39:02,586888000
16.12.09 09:54:32,530035000
16.12.09 09:57:11,292928000

Looks like there is an internal conversion to VARCHAR.
Can it be fixed (or configured somewhere)?

PL/SQL-Developer Version 8.0.1.1502
Oracle-Server: Oracle 11.1.0.7

Kind regards,
Lutz

 

[Marco Kalter]

Timestamp values are indeed sorted as character values. To sort them correctly, you will have to change the NLS_TIMESTAMP_FORMAT accordingly. For example: YYYY-DD-MM HH24:MI:SSXFF