select * from 表 where datediff(dd,dateadd(yy,datediff(yy,生日字段,getdate()),生日字段),getdate()) between 2 and 3
select * from tb where ('2005-11-10'-sdate)<2 '2005-11-10'要计算时间差的起点,可以自己设定 sdate为数据库中存放生日的列名 2为相差的天数
Select * from news Where DateAdd(year,Year(Getdate())-Year(rq),rq) Between Convert(Varchar(10),Getdate(),120) And Convert(Varchar(10),Getdate()+90,120) or DateAdd(year,Year(Getdate())-Year(rq)+1,rq) Between Convert(Varchar(10),Getdate(),120) And Convert(Varchar(10),Getdate()+90,120)
select * from 表名 where DATEDIFF(dd,生日字段,getdate()) between 2 and 3
where
datediff(dd,dateadd(yy,datediff(yy,生日字段,getdate()),生日字段),getdate()) between 2 and 3
'2005-11-10'要计算时间差的起点,可以自己设定
sdate为数据库中存放生日的列名
2为相差的天数
Where
DateAdd(year,Year(Getdate())-Year(rq),rq)
Between
Convert(Varchar(10),Getdate(),120)
And Convert(Varchar(10),Getdate()+90,120)
or
DateAdd(year,Year(Getdate())-Year(rq)+1,rq)
Between
Convert(Varchar(10),Getdate(),120)
And Convert(Varchar(10),Getdate()+90,120)