Date ordering problem

From: M2 <mmortonallen_at_csu.edu.au>
Date: Thu, 04 Jan 2001 06:35:47 GMT
Message-ID: <9315k3$ki3$1@nnrp1.deja.com>

Hi All,
I have what appears to be a simple problem but I just can't get my head around it. I have the following query in a report how many actions were performed on a given day:

select

to_char(date_logged, 'DD-MON-YYYY'), count(*) from

log
group by

to_char(date_logged, 'DD-MON-YYYY')
order by

to_char(date_logged, 'DD-MON-YYYY)

My problem is that I need this to be in chronological order and it's in asciibetical order. I have tried lots of combinations of things but I always run into a problem. If anyone could shed some light on this for me I would really appreciate it.

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 00:35:47 CST