Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

group by month of the date

user613239Jan 7 2008 — edited Jan 7 2008
I need to generate a report based on the month of a date field.its look like

month arrived patients
May 100
june 129
July 154
.........................


How can i write the group by select command on the field of a date. Kindly help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2008
Added on Jan 7 2008
9 comments
53,140 views