Use test
-->>-->> Andy 2008-6-22
Set Nocount ON
Declare
@1 datetime,
@2 datetime
Select
@1='2006-7-8',
@2='2008-6-10'
Select
Rtrim(Datediff(Year,@1,@2)-Case When Month(@2)>=Month(@1) Then 0 Else 1 End)+'年'+
Rtrim(Datediff(Month,@1,@2)%12-Case When Day(@2)>=Day(@1) Then 0 Else 1 End)+'月'+
Rtrim(Case When Day(@2)>=Day(@1) Then Day(@2)-Day(@1) Else Datediff(Day,@1,DateAdd(Month,1,@1))-Day(@1)+Day(@2) End)+'天'
/*
1年11月2天
*/