（3期）计算两个时间差（*天*小时*分*秒）

if OBJECT_ID('fn_calcTime','fn') is not null drop function fn_calcTimegocreate function fn_calcTime(@dateStart datetime,@dateEnd Datetime)returns varchar(128)asBegindeclare @day intdeclare @hour intdeclare @min intdeclare @sec intdeclare @alls intdeclare @value varchar(128)--//计算两个时间差（秒）set @alls=datediff(s,@dateStart,@dateEnd)--//根据秒计算 天数set @day=@alls/86400--//根据秒-天数 计算小时set @hour=(@alls-@day*86400)/3600--//根据秒-天数-小时 计算分钟set @min=(@alls-@day*86400-@hour*3600)/60--//计算秒set @sec=@alls-@day*86400-@hour*3600-@min*60if @dateStart<@dateEndBeginselect @value=CAST(@day as varchar(5))+'天'+CAST(@hour as varchar(2))+'小时'+CAST(@min as varchar(2))+'分'+CAST(@sec as varchar(2))+'秒'End else Beginset @value='Error'Endreturn @valueendgoselect dbo.fn_calcTime('2009-11-24 00:00:00','2009-11-24 05:12:24')