SqlServer怎么查询某年某月的工作日天数

最新推荐文章于 2024-05-11 21:37:06 发布

薄荷琴糖

最新推荐文章于 2024-05-11 21:37:06 发布

阅读量1.4k

点赞数

文章标签： sqlserver 数据库 database

本文链接：https://blog.csdn.net/growb/article/details/123499022

版权


--创建函数（传入年和月份）
create  function getWorkDays( @year int , @month int )
returns int as 
begin 
    declare @CountDay int  
    declare @temptime datetime
    set @CountDay = 0 
    set @temptime = convert(varchar,@year) + '-'+ convert(varchar,@month) + '-01' 
     while(MONTH(@temptime) = @month)
     begin
         if DATEPART(weekday,@temptime) <>1 and DATEPART(weekday,@temptime)<>7
          begin
             set @CountDay = @CountDay + 1 
           End
        set @temptime = DATEADD(day,1,@temptime)
     end
    return @CountDay
end 

--调用
select dbo.getWorkDays(2009,7)