declare @a datetime,@b datetime,@c datetime,@d datetime
set @a='2003-9-1 12:39'
set @b='2003-9-5 11:55:58'
set @c=@b-@a
set @d=convert(varchar(20),@c,108)
select cast(cast(day(@c) as varchar)+'天'+cast(datepart(hour,@d) as varchar)+'小时'+cast(datepart(minute,@d) as varchar)+'分'+cast(datepart(second,@d) as varchar)+'秒' as varchar(30)) as 时间差
go
declare @a datetime,@b datetime,@c datetime
set @a='2003-9-1 12:39'
set @b='2003-9-5 11:55:58'
set @c=@b-@a
select cast(day(@c) as varchar)+'天 '+convert(varchar(8),@c,108) as 时间差
go