how can i get the date in "Month Year" format?

Question

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?

See this compilation of date conversions: sql-server-helper.com/tips/date-formats.aspx (first hit on searching for sql server date formatting in Google) — MicSim
– MicSim, Commented Aug 8, 2011 at 15:23

Curtis · Accepted Answer · 2011-08-08 15:19:37Z

4

SELECT DATENAME(month, getdate()) + ' ' + DATENAME(year, getdate())

answered Aug 8, 2011 at 15:19

104k69 gold badges280 silver badges359 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1