根据时间段计算的方法:
| 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天
*/

