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]