sql server 时间有关问题

sql server 时间问题select id, case whenarticleTime between (dateadd(day,-7,getdate())) anddateadd(d

sql server 时间问题
select id, case when  articleTime between (dateadd(day,-7,getdate())) and  dateadd(day,7,getdate()) then 1 else 0  end articleTime from articleTest