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