本文介绍了如何计算“星期二"的数量在 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 中的两个日期之间?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-24 01:11