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 DAY , MONTH and YEAR from current date using sql query?

| | SQL

In this article, I found a sql query to find day, month and year from the current or any date using inbuilt functions such as DATEPART() or DAY(), MONTH() and YEAR() functions. 

SELECT
DATEPART(DD,GETDATE()) AS Day,
DATEPART(MM,GETDATE()) AS Month,
DATENAME(YYYY,GETDATE()) AS Year

(OR)
 
SELECT
DATEPART(DAY,GETDATE()) AS Day,
DATEPART(MONTH,GETDATE()) AS Month,
DATEPART(YEAR,GETDATE()) AS Year
 

Output

--------

Day         Month       Year

21          3           2016