On Thu, 12 Sep 2002 [EMAIL PROTECTED] 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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
