Current Month and year in sql server 2008 r2 [closed]

Question

I am currently new in C# & SQL.

How do I get the current month and year in SQL Server 2008 R2?

Answer 1

SQL Server

SELECT GETDATE() AS CurrentDateTime
     , YEAR(GETDATE()) AS CurrentYear
     , MONTH(GETDATE()) AS CurrentMonth

C#

var now = DateTime.Now;
var currentYear = now.Year;
var currentMonth = now.Month;