Re: Question about grouping by month

mario wrote:
>
> Hi,
>
> I'm learning Oracle, so the question maybe has no sense, but anyway...
>
> I'd like to make a report (with Oracle's report builder) in which the
> records are grouped by month. The problem is that i don't know how to parse
> the month from the whole date, to group by it. ( Of course, if the value of
> the month is the same but the year is different, this is another group.)
> I thought to do that in the
>
> Thanx

select to_char(date_col,'MM') ...

select trunc(date_col,'MM') ..

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."