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