c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
SQL

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

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