Column timestamp order --> normal or not

[bertrand]

Hello , i have a sysdhc ( timestamp(6)) column in my table
When i click on the little button at the right of my column name , the "order by" make as it was a text colum --> is it normal ?

 

[Marco Kalter]

Timestamps are sorted as string on the client side. Therefore you either need to modify the "order by" clause for server side sorting, or use an NLS_TIMESTAMP_FORMAT and/or NLS_TIMESTAMP_TZ_FORMAT that starts with "YYYY/MM/DD" so that string sorting will lead to the correct result.