>>declare @d datetime = '2009-09-15 10:40:20' >> >>select DATEDIFF(year, @d, CURRENT_TIMESTAMP) as [Years], >>DATEDIFF(month, @d, CURRENT_TIMESTAMP) as [Months], >>DATEDIFF(day, @d, CURRENT_TIMESTAMP) as [Days]>>
> Dim earlierDate As New DateTime(2007, 8, 5, 10, 15, 0) >>
Years Months Days
4 50 1521