>>
>>Years Months Days
>>4 50 1521
>
>I am not sure if this is really a timespan difference. In my case, I only want the remaining portion of each subset. So, in this case, it should give 4 years, 1 month and 29 days.
In SQL Server there is no function (AFAIK) that gives the difference. All DATEDIFF values are absolute (number of full months passed, number of full days passed, etc.). So, we need to do the calculation there ourselves.
If it's not broken, fix it until it is.
My Blog