Re: How to group a date field by month or day ?

I believe you want TO_CHAR(yourdatefield,'MM'). This will return the 2 byte index for month.

Michael Keppler wrote in message <7pgiql$npi_at_TGZ3>...
>Hello there !
>
>In local SQL I used "EXTRACT(MONTH FROM datefield) AS M" to get the
>month information out of a date field. How do I write this statement for
>Oracle SQL to group my data by month ??
>
>Thanks and Good Bye, Michael.
>--
>Michael.Keppler_at_bigfoot.com
>
>
Received on Thu Aug 19 1999 - 08:33:16 CDT