Re: Question about grouping by month

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 07 Feb 2002 20:35:48 GMT
Message-ID: <3C62E529.BEE2839E_at_ci.seattle.wa.us>


Look at the options in the TO_CHAR function for getting the month.

Try this, for example:

SELECT TO_CHAR(SYSDATE, 'MON')
FROM dual;

That should give you a good hint on how to go about it.

Daniel Morgan

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
Received on Thu Feb 07 2002 - 21:35:48 CET

Original text of this message