declare @b datetime,@e datetime
set @b = '2003-12-20'
set @e = '2004-01-21'

select datediff(week,@b,@e)
,datediff(week,@b,@e) + case when datepart(weekday,@b) > 1 then 0 else 1 end - case when datepart(weekday,@e) >= 1 then 0 else 1 end as 周日數(shù)
,datediff(week,@b,@e) + case when datepart(weekday,@b) > 2 then 0 else 1 end - case when datepart(weekday,@e) >= 2 then 0 else 1 end as 周一數(shù)
,datediff(week,@b,@e) + case when datepart(weekday,@b) > 3 then 0 else 1 end - case when datepart(weekday,@e) >= 3 then 0 else 1 end as 周二數(shù)
,datediff(week,@b,@e) + case when datepart(weekday,@b) > 4 then 0 else 1 end - case when datepart(weekday,@e) >= 4 then 0 else 1 end as 周三數(shù)
,datediff(week,@b,@e) + case when datepart(weekday,@b) > 5 then 0 else 1 end - case when datepart(weekday,@e) >= 5 then 0 else 1 end as 周四數(shù)
,datediff(week,@b,@e) + case when datepart(weekday,@b) > 6 then 0 else 1 end - case when datepart(weekday,@e) >= 6 then 0 else 1 end as 周五數(shù)
,datediff(week,@b,@e) + case when datepart(weekday,@b) > 7 then 0 else 1 end - case when datepart(weekday,@e) >= 7 then 0 else 1 end as 周六數(shù)

總結

以上是生活随笔為你收集整理的判断时间段内有几个休息期的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。