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.
Thanks in advance