如何计算“星期二"的数量在 TSQL 中的两个日期之间? [英] How to calculate the number of "Tuesdays" between two dates in TSQL?

问题描述

我想弄清楚如何计算 TSQL 中两个日期之间的星期二"数?

I'm trying to figure out how to calculate the number of "Tuesdays" between two dates in TSQL?

Tuesday"可以是任何值.

"Tuesday"could be any value.

推荐答案

谢谢 t-clausen.dk，节省了我几天时间.要获得每天的实例数:

Thank you t-clausen.dk, Saved me few days. To get no of instances of each day:

declare @from datetime= '3/1/2013' 
declare @to datetime  = '3/31/2013' 


select 
 datediff(day, -7, @to)/7-datediff(day, -6, @from)/7 AS MON,
 datediff(day, -6, @to)/7-datediff(day, -5, @from)/7 AS TUE,
 datediff(day, -5, @to)/7-datediff(day, -4, @from)/7 AS WED,
 datediff(day, -4, @to)/7-datediff(day, -3, @from)/7 AS THU,
 datediff(day, -3, @to)/7-datediff(day, -2, @from)/7 AS FRI,
 datediff(day, -2, @to)/7-datediff(day, -1, @from)/7 AS SAT,
 datediff(day, -1, @to)/7-datediff(day, 0, @from)/7 AS SUN

这篇关于如何计算“星期二"的数量在 TSQL 中的两个日期之间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！