SQL查询3月5号，然后把5号前10天和后10天的数据 都查出来咱们写？

Question

SQL查询3月5号，然后把5号前10天和后10天的数据 都查出来咱们写？

Answer 1

select * from tab where date between dateadd(d,-10,getdate()) and dateadd(d,10,getdate())

Answer 2

select dateadd(day,-10,getdate()),dateadd(day,10,getdate())
select dateadd(day,-10,'2010-03-05'),dateadd(day,10,'2010-03-05')
/*----------------------- -----------------------
2010-02-26 11:45:15.360 2010-03-18 11:45:15.360(1 行受影响)                        
----------------------- -----------------------
2010-02-23 00:00:00.000 2010-03-15 00:00:00.000(1 行受影响)*/

Answer 3

纠正
select * from tab where [date] between dateadd(d,-10,[date]) and dateadd(d,10,[date])

Answer 4

select * 
from tb 
where dt='2010-03-05'
or dt=dateadd(day,-10,'2010-03-05')
or dt=dateadd(day,10,'2010-03-05')