Showing posts with label Getting only Month and Year from Date. Show all posts
Showing posts with label Getting only Month and Year from Date. Show all posts

Wednesday, November 30, 2011

Getting only Month and Year from Date

Select[YEAR] = YEAR(getdate()), [YEAR] = DATEPART(YY,getdate()), [MONTH] = MONTH(getdate()),
[MONTH] = DATEPART(MM,getdate()), [MONTH NAME] = DATENAME(MM, getdate())