Now i am in a condition, Where I am just displaying the month names and some data grouped by month number. There is a small issue. I need to get month names instead of month numbers from Oracle.
here's my query
SELECT Count(*),EXTRACT (MONTH FROM DATE_CREATED),EXTRACT (YEAR FROM DATE_CREATED) FROM MyTable GROUP BY EXTRACT (YEAR FROM DATE_CREATED) ,EXTRACT (MONTH FROM DATE_CREATED)
And the result is 3 columns. Count, Month(Number) and year
something like this
3 10 2006
Please anyone help to convert the month number to month name in oracle or C#. Problem is I cannot use the data formatting functions as this is a single number appearing.
Champ0308
Member
18 Points
25 Posts
Display Month Names from month numbers
Oct 11, 2007 01:58 PM|LINK
Now i am in a condition, Where I am just displaying the month names and some data grouped by month number. There is a small issue. I need to get month names instead of month numbers from Oracle.
here's my query
SELECT Count(*),EXTRACT (MONTH FROM DATE_CREATED),EXTRACT (YEAR FROM DATE_CREATED) FROM MyTable GROUP BY EXTRACT (YEAR FROM DATE_CREATED) ,EXTRACT (MONTH FROM DATE_CREATED)
And the result is 3 columns. Count, Month(Number) and year
something like this
3 10 2006
Please anyone help to convert the month number to month name in oracle or C#. Problem is I cannot use the data formatting functions as this is a single number appearing.
Thanks for any help!!!!!!!!!!!!!!!