>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)And, tell me the numbers you get?