Convert date to month name

[dwight1]

Can any one advise how to convert date to alpha month.

For example.

10/31/2005 as October 2005 or October

Thanks

Dwight

 

[SQLDenis]

SELECT DATENAME(month, '10/31/2005') AS 'Month Name',
DATENAME(month, '10/31/2005') + ' ' + DATENAME(year, '10/31/2005') AS 'MonthYear Name'


“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[SQLBill]

I've never had the need to do that, so I don't have a script handy. But it has come up several times, so do a search on this forum and you should find a solution.

-SQLBill

Posting advice: FAQ481-4875

 

[dwight1]

Thank you.

Dwight

 

[VBrit]

Hi Dwight,

easy as:

SELECT datename(m,getdate()) + ' ' + cast(year(getdate()) as char(4))

OR

SELECT datename(m,getdate()) + ' ' + datename(yyyy,getdate())

I would guess that the 2nd version might be a bit slower, but not sure what SQL is doing internally to return the year...