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
发布时间： 2012-08-26 16:48:06 作者： rapoo
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