if OBJECT_ID('fn_calcTime','fn') is not null drop function fn_calcTime
go
create function fn_calcTime(@dateStart datetime,@dateEnd Datetime)
returns varchar(128)
as
Begin
declare @day int
declare @hour int
declare @min int
declare @sec int
declare @alls int
declare @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*60
if @dateStart<@dateEnd
Begin
select @value=CAST(@day as varchar(5))+'天'+CAST(@hour as varchar(2))+'小时'+CAST(@min as varchar(2))+'分'+CAST(@sec as varchar(2))+'秒'
End
else
Begin
set @value='Error'
End
return @value
end
go
select dbo.fn_calcTime('2009-11-24 00:00:00','2009-11-24 05:12:24')
(3期)计算两个时间差(*天*小时*分*秒)
最新推荐文章于 2021-06-16 17:01:04 发布