ALTER FUNCTION [dbo].[F_worktotalminues](@dt_begin DATETIME, @dt_end DATETIME ) RETURNS INT AS BEGIN DECLARE @holidDay INT set @holidDay = 0 DECLARE @totalminues INT set @totalminues = 0 declare @inidt_begin datetime set @inidt_begin = @dt_begin WHILE @dt_begin <= @dt_end BEGIN set @totalminues = case when (@@datefirst + datepart(weekday,@dt_begin)-1)%7 between 1 and 5 then @totalminues + 1 else @totalminues end set @dt_begin = dateadd(mi,1,@dt_begin) END RETURN case @totalminues when 0 then 0 else @totalminues - 1 end END
两日期间的工作日分钟数(只排除了周六周日)
最新推荐文章于 2020-08-27 11:59:19 发布