Monday, December 06, 2010

Convert YYYYMM Integer Date to Datetime and retrieve month name

SELECT DATENAME(MONTH, DATEADD(mm,(((YYYYMM/100)-1900)*12)+(YYYYMM%100)-1,0)) AS MonthName FROM

No comments:

Post a Comment