CODEWITHSUNDEEP
sqlsql-server
cici12
cici12

Reputation: 13

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?

Upvotes: 0

Views: 526

Answers (1)

Curtis
Curtis

Reputation: 103428

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

Upvotes: 4

Related Questions