Extract Month from System date as 'January', 'February', etc

[Cognuser]

I am building a report in report studio and I need to extract the 'month' from the system date as one of my data items.

So if the system date is 'January 24, 2011' is want to extract 'January' and display this on my report. 

When I use extract I only get the number 1???

[MFGF]

Hi,

If you just need the day name to display, leave the date column intact, then use the Format option to define you want the day name to display and nothing else.

Regards,

MF.

[Cognuser]

Thank you I will try that.  Thank you for your quick response.

[Mahendra]

Hi i think the below will help you,

   Take a data item and place the to_char({sysdate},'MONTH')
code into expression window.
and use this where ever you require.