日期:2014-05-18 浏览次数:20471 次
set datefirst 1 select * from tb where date between '2010-01-20' and '2012-03-01' and day(date) = (case when datepart(weekday,date) in (6,7) and day(date) = 5 then 10-datepart(weekday,date) else 5 end) -- try