Thread: still sorting and casting problems
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 __________________________________________________
On Thu, 12 Sep 2002 juerg.rietmann@pup.ch wrote: > > 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 What do you get when trying this last query (something of the sort works for me in 7.3beta). It's possibly that you might need to use date(log_date::text) desc, but without the error it's hard to say.
--- juerg.rietmann@pup.ch wrote: > 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 > You haven't shown the error message here, but I'm guessing that there is no direct cast between char and date available in PostgreSQL. Try casting first to text, then to date. __________________________________________________ Do you Yahoo!? Yahoo! News - Today's headlines http://news.yahoo.com