SQL Authors
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())
Older Posts
Home
Subscribe to:
Posts (Atom)