sql server一周时间（周一到周日时间）

直接上代码

with t as (
select (case when DatePart(w,getdate())= 1 then 7 else 0 end) as num
)

SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), -1)+1-t.num,DATEADD(hh,8, DATEADD(wk, DATEDIFF(wk,0,getdate()+7), -1))+1-t.num,getdate()
from t