--查询的参数
declare @dt varchar(10)
set @dt='6-26'--查询的示例
select * from 表
where datediff(day,dateadd(year,year(日期字段)-1900,'1900-'++@dt),日期字段) between -10 and 10
declare @dt varchar(10)
set @dt='6-26'--查询的示例
select * from 表
where datediff(day,dateadd(year,year(日期字段)-1900,'1900-'++@dt),日期字段) between -10 and 10
declare @dt varchar(10)
set @dt='6-26'--查询的示例
select * from 表
where datediff(day,dateadd(year,year(日期字段)-1900,'1900-'++@dt),日期字段) between -10 and 0 --那就改改这个时间范围嘛,如果不包含今天,将0改成-1