如何计算数据库中的时间范围

Question

--本周
select * from datediff(week,insert_time,getdate()) = 0--七天之内
select * from datediff(day,insert_time,getdate()) <= 7

Answer 1

SELECT * FROM TB WHERE DATEDIFF(WEEK,DT,GETDATE())=0 --本周SELECT * FROM TB WHERE DATEDIFF(DAY,DT,GETDATE())<=7 --７天之内

Answer 2

insert_time>convert(varchar(10),getdate-7,120)

Answer 3

--本周 
select * from where datediff(week,insert_time,getdate()) = 0 --七天之内 
select * from where datediff(day,insert_time,getdate()) <= 7 MD,今天头有点晕,把where都写掉了