How To Get Year , Month , Date In Numeric ?
Satyaprakash Samantaray
select year(GETDATE()) --Year select month(GETDATE()) --Month select day(GETDATE()) --Day
By the function datetime
SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 101) AS [MM/DD/YYYY]