Link to home
Start Free TrialLog in
Avatar of tmitch1968
tmitch1968

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tmitch1968
tmitch1968

ASKER

Thanks!