SQL

How to get DAY , MONTH and YEAR from current date using sql query?

How to get DAY , MONTH and YEAR from current date using sql query?, someone asked me to explain?
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

Post your comments / questions