Full Month Name

Is there a convert date function that will allow 2006-01-01 00:00:00.000
to be returned as 'January 2006'?
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
SELECT DATEPART(m, DateColumn) & ' ' & CAST(YEAR(DateColumn) AS varchar) AS MonthAndYear
FROM SomeTable
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
select DATENAME(month,'2006-01-01 00:00:00.000') + ' '+CAST(YEAR(' 2006-01-01 00:00:00.000')AS VARCHAR)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.