sql server - Getting only Month and Year from SQL DATE - Stack Overflow
I need to access only Month.Year from Date field in SQL Server. . ... I am interpreting your question in two ways. a) You only need Month & Year seperately in which case here is the answer select [YEAR] = YEAR(getdate()) ,[YEAR] = DATEPART(YY ......