how can i get the date in "Month Year" format?
I'm currently using this piece of code to get month and year.
CONVERT(varchar, DATEPART(year, StartDate)) + '-' + RIGHT('0' + CONVERT(varchar, DATEPART(month, 开发者_高级运维StartDate)), 2) As Month
but it returns "2011-06"
My Startdate format = 2011-06-15 14:03:00
I would like to get this into "June 2011" - how can I do that?
SELECT DATENAME(month, getdate()) + ' ' + DATENAME(year, getdate())
精彩评论