How Convert specific String To Month Name

Question

Example: my database table data is 201201 which i want to display as 2012 DECEMBER . Please advice me. SQL 2005 Environment.

Answer 1

How about this?

DECLARE @DT DATETIME
SET @DT = CONVERT(DATETIME,'201201' + '01')

SELECT  CAST(YEAR(@DT) AS VARCHAR(4)) + ' ' + DATENAME(MM, @DT) AS [Month YYYY]