Re: Date ordering problem

If you need a date sort of the column date_logged then you just have to leave this column in date format...

So try this:

select to_char(date_logged, 'DD-MON-YYYY')

      ,count(*)
  from log
 group by to_char(date_logged, 'DD-MON-YYYY')  order by date_logged
/

Roger

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 02:03:37 CST