sql语句求助？？？

Question

例如：
表：T1，字段：id,AssignDate需求：要求查出"当前时间">AssignDate字段时间72小时的ID。除去周六周日。问题关键是如何除去周六周日。多谢帮忙！！

Answer 1

DATEPART(weekday,AssignDate )>1 and SELECT DATEPART(weekday,AssignDate )<7

Answer 2

SELECT * FROM T1 WHERE AssignDate> DATEADD(HH,-72,GETDATE()) AND DATEPART(WEEKDAY,AssignDate) BETWEEN 2 AND 5

Answer 3

where AssignDate <dateadd(day,-case when datepart(weekday,getdate()) in (1,2,3,4) then 72+48 when datepart(weekday,getdate()) =7 then 72+24 else 72 end,getdate())

Answer 4

SELECT * FROM T1 WHERE AssignDate> DATEADD(HH,-72,GETDATE()) AND DATEPART(WEEKDAY,AssignDate) BETWEEN 2 AND 5第一天默认是Sunday 时

Answer 5

SELECT * FROM T1 WHERE AssignDate> DATEADD(HH,-72,GETDATE()) AND DATEPART(WEEKDAY,AssignDate) BETWEEN 2 AND 5