group by month ?

i have a field that stores the date /time .

how do i group the resultset by month ?

meaning, it shows :-

1999 Jul count1

       Aug  count2
       Sep
       Oct

i heard that i need to use to_char(date) to convert the date/time to a char .

then, i need to count the no of occurances of jan 1999, feb 1999, march 1999 and so on.

Any idea how this could be done ?

Thanks a lot.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 21:46:59 CDT