Problem with order when selecting

Dear SQL hackers,

I would like to do the following:

select

        to_char(first_time),
        count(first_time)
from v$log_history
        group by to_char(first_time)
        order by first_time

Unfortunately this does not work.
However when I:

order by to_char(first_time)

I don't get the order I want.

Can some one please show me how this is ment to work!

Thanks in advance.

Roman Klesel Received on Wed Jul 07 2004 - 17:18:00 CDT