计算两个日期之间的工作日 [英] Count work days between two dates

问题描述

如何计算SQL Server中两个日期之间的工作天数？

How can I calculate the number of work days between two dates in SQL Server?

周一至周五，必须是T-SQL。

Monday to Friday and it must be T-SQL.

推荐答案

对于周一至周五的工作日，您可以使用单个SELECT进行操作：

For workdays, Monday to Friday, you can do it with a single SELECT, like this:

DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SET @StartDate = '2008/10/01'
SET @EndDate = '2008/10/31'


SELECT
   (DATEDIFF(dd, @StartDate, @EndDate) + 1)
  -(DATEDIFF(wk, @StartDate, @EndDate) * 2)
  -(CASE WHEN DATENAME(dw, @StartDate) = 'Sunday' THEN 1 ELSE 0 END)
  -(CASE WHEN DATENAME(dw, @EndDate) = 'Saturday' THEN 1 ELSE 0 END)

如果你想包括假期，你必须工作一点...

If you want to include holidays, you have to work it out a bit...

这篇关于计算两个日期之间的工作日的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！