Re: Question about grouping by month

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3C62EC76.1C1_at_yahoo.com...
> 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..."

[Quoted] Hey, thanx...it works! Received on Fri Feb 08 2002 - 12:38:13 CET