Converting DateTime to nvarchar, just month and year

Question

How to convert the datetime value to nvarchar and want to format it "Month, Year" e-g October 1st 2009 value should get converted to "October, 2009"

Answer 1

use this:

select CONVERT(nvarchar(50),   DATENAME(m, getdate()) 
                               + ', ' 
                               + DATENAME(yyyy, getdate())
              )

OUTPUT:

--------------------------------------------------
October, 2009

(1 row(s) affected)