delete from 表 where abs(datediff(d,日期字段,getdate())<=7
delete from 表 where datediff(day,日期字段,getdate()) between 0 and 7 我的表tour_language id sandtime 1 2005-09-07 15:19:10 2 2005-09-07 15:19:20 3 2005-09-07 15:19:30 .. ..... 为了测试我把时间改成秒级 time还不能替换 delete from tour_language where datediff(day,sendTime,getdate()) between 0 and 60between 0 and 7 则么在0~7之间那?当前时间-插入时间>7
delete from 表 where abs(datediff(d,日期字段,getdate())=7
where abs(datediff(d,日期字段,getdate())<=7
where datediff(day,日期字段,getdate()) between 0 and 7
我的表tour_language
id sandtime
1 2005-09-07 15:19:10
2 2005-09-07 15:19:20
3 2005-09-07 15:19:30
.. .....
为了测试我把时间改成秒级 time还不能替换
delete from tour_language
where datediff(day,sendTime,getdate()) between 0 and 60between 0 and 7 则么在0~7之间那?当前时间-插入时间>7
where abs(datediff(d,日期字段,getdate())=7