Pages

Men

rh

4/22/2013

How to get Month Names by Year in SQL Server

SELECT  DISTINCT CONVERT(VARCHAR(30), WEEKDATE,100) AS MONTH_NAME FROM 
TBL_TEMPDATA WHERE YEAR(WEEKDATE) = 2012

No comments :

Post a Comment