Re: Date ordering problem

Hi,
umm I neglected to mention that I need the report to supply to DD-MON- YYYY format even though I need it sorted by something like YYYYMMDD.

Matt.

In article <9315k3$ki3$1_at_nnrp1.deja.com>,   M2 <mmortonallen_at_csu.edu.au> wrote:
> 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/
>

--
==================================
signature file
==================================


Sent via Deja.com
http://www.deja.com/