select * from tb where 出生日期字段 between dateadd(day,-7,要查的日期) and dateadd(day,7,要查的日期)
where datediff(day,dateadd(year,datediff(year,生日,getdate()),生日),getdate())<7
where 出生日期 between dateadd(year,datediff(year,getdate(),出生日期),dateadd(day,-7,getdate())) and dateadd(year,datediff(year,getdate(),出生日期),dateadd(day,7,getdate()))
where abs(datediff(dd,查询日期,比较日期)) <= 7
我现在假设你包含前后各七天.select * from tb where abs(datediff(day,datename(year) + right(convert(varchar(10),时间字段,120),6),getdate())) <= 7如果只是从今天开始算,之后的七天. select * from tb where datediff(day,getdate(),datename(year) + right(convert(varchar(10),时间字段,120),6)) between 1 and 7
select * from tb
where 出生日期字段 between dateadd(day,-7,要查的日期) and dateadd(day,7,要查的日期)
我现在假设你包含前后各七天.select * from tb where abs(datediff(day,datename(year) + right(convert(varchar(10),时间字段,120),6),getdate())) <= 7如果只是从今天开始算,之后的七天.
select * from tb where datediff(day,getdate(),datename(year) + right(convert(varchar(10),时间字段,120),6)) between 1 and 7