Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to group a date field by month or day ?
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 - 04:34:47 CDT