Current month and year in SQL Server 2008 r2

Question

I am currently new to C # and SQL.

How to 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 

WITH#

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