Hello there
Unfortunately, I can't change the fieldtype that easy because other applications use the date as char(10) field as well. I need to sort the query by the log_date desc (log_date is char(10)). I tried the following without success : select id, log_date from userlog order by cast (log_date as date) desc select id, log_date from userlog order by date(log_date) desc Please help and thank's in advance ... jr __________________________________________________ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland internet : www.pup.ch phone : +4141 790 4040 fax : +4141 790 2545 mobile : +4179 211 0315 __________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html