获取年月日

SELECT YEAR(GETDATE()), MONTH(GETDATE()), DAY(GETDATE())

SELECT YEAR(s.time), MONTH(s.time), DAY(s.time) ,s.* FROM dbo.Student s