In SQL, how do you format a date to give you the full month?

Hello,

I have an SQL query that returns a date object.

I can get the query to return the month as an integer like this

to_char(item.ENTRY_DATE, 'MM') as Month

For example, a date with the month of September would be 09.

However, what I really need is for the month to be returned as its actual name - ie:  'September' or even 'Sep'

I've tried DATENAME, DATE_FORMAT, and a few other things.  None of these work.


Any suggestions?

Thanks in advance