1 select CONVERT(nvarchar(10), getdate(), 120) 2 3 4 select DATEPART (year, GETDATE()) 5 6 7 select DATEPART (month , GETDATE()) 8 9 10 select DATEPART (day , GETDATE())