Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
18 Points
25 Posts
Oct 11, 2007 03:00 PM|LINK
I got it!!!!!!!!!!!!!!!!!!!!
Select count(*), EXTRACT (MONTH FROM DATE_CREATED),to_char(date_created,'MONTH')month_created FROM MyTable WHERE EXTRACT (YEAR FROM DATE_CREATED) = '2007' GROUP BY EXTRACT (MONTH FROM DATE_CREATED) ,to_char(date_created,'MONTH')
Thanks Prashant and have a nice day
Champ0308
Member
18 Points
25 Posts
Re: Display Month Names from month numbers
Oct 11, 2007 03:00 PM|LINK
I got it!!!!!!!!!!!!!!!!!!!!
Select count(*), EXTRACT (MONTH FROM DATE_CREATED),to_char(date_created,'MONTH')month_created FROM MyTable WHERE EXTRACT (YEAR FROM DATE_CREATED) = '2007' GROUP BY EXTRACT (MONTH FROM DATE_CREATED) ,to_char(date_created,'MONTH')
Thanks Prashant and have a nice day