declare @date datetime set @date=dateadd(day,-7,getdate()) if (datepart(month,@date)=10) and (datepart(day,@date) between 1 and 3) print '在10.1和10.3之间' else print '不在'
select cc from a where dateadd(day,-7,cc) between '2005-10-01' and '2005-10-03'
dateadd(day,-7,getdate()) between '2005-10-01' and '2005-10-03'
set @date=dateadd(day,-7,getdate())
if (datepart(month,@date)=10) and (datepart(day,@date) between 1 and 3)
print '在10.1和10.3之间'
else
print '不在'