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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER