Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: group by month ?
select count(*),to_char(date_field,'YYYYMM') from your_table
group by to_char(date_field,'YYYYMM');
javanewbie_at_my-deja.com wrote in message <7v5p32$3bq$1_at_nnrp1.deja.com>...
>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 - 22:33:35 CDT