我可以计算一下SQL Server中两个日期之间有多少个周末吗？ [英] Can I calculate there's how many weekend days between two dates in SQL Server?

问题描述

我正在计算用于报告的租赁设备的收入。因此，与正常工作日相比，周末工作日的雇用成本将增加10％。因此，我该如何计算两个日期之间有多少个周末。在报表查询中，我也无法使用DECLARE。有人可以帮我做到这一点。非常感谢

I'm calculating income of hiring equipments for a report. In that, hiring cost in weekend days will be plus 10% more if compare with normal days. So how can I calculate there's how many weekend days between two dates. And in report query, I can't use DECLARE also. Can someone help me to do this. Thank you so much

推荐答案

这应该有效：

DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SET @StartDate = '2012/11/01'
SET @EndDate = '2012/11/05'


SELECT
  (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)

http://sqlfiddle.com/#!3/ d41d8 / 5707/0

这篇关于我可以计算一下SQL Server中两个日期之间有多少个周末吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！