Hello ,
Please try this code as below you get result as you want ..
declare @d1 datetime, @d2 datetime, @y int, @m int, @d int
set @d1 = '2010-09-05'
set @d2 = '2013-09-05'
set @y = datediff(year, @d1, @d2) - 1
set @m = datediff(month, dateadd(year, @y, @d1), @d2)
if dateadd(month, @m, dateadd(year, @y, @d1)) > @d2 set @m = @m - 1
set @d = datediff(day, dateadd(month, @m, dateadd(year, @y, @d1)), @d2)
if @m = 12 set @y += 1
print cast(@y as nvarchar) + ' year(s) '