SQL

How to get current year,month,day in sql server?

How to get current year,month,day in sql server?, someone asked me to explain?
SQL

In GETDATE() function will return current date and time from the SQL Server.

To get current year, I combine YEAR with GETDATE = YEAR(GETDATE());

select  YEAR(GETDATE())AS current_year;
select
datepart(yyyy,getdate())AS current_year;

select datepart(MM,getdate()) AS current_month;
select datepart(dd,getdate()) AS current_day;

OUTPUT:

current_year
2016
 

current_year
2016
 

current_month
2
 

current_day
18
2016 //current year
2016 //current year
2 //current Month
18 //current day

 

Post your comments / questions