--建立测试环境
Create table [TEST]
(IDInt,
BirthdayVarchar(10))
--插入数据
Insert [TEST] Values(1,'1981/12/26')
Insert [TEST] Values(2,'1977/02/26')
Insert [TEST] Values(3,'1978/07/05')
Insert [TEST] Values(4,'1979/08/01')
Insert [TEST] Values(5,'1980/07/27')
Insert [TEST] Values(6,'1980/07/25')
GO
--测试
Select * from TEST
Where DateAdd(year,Year(Getdate())-Year(Birthday),Birthday)
Between Convert(Varchar(10),Getdate(),120)
And Convert(Varchar(10),Getdate()+30,120)
--删除测试环境
Drop Table TEST
--结果
/*
IDBirthday
41979/08/01
51980/07/27
61980/07/25
*/
Create table [TEST]
(IDInt,
BirthdayVarchar(10))
--插入数据
Insert [TEST] Values(1,'1981/12/26')
Insert [TEST] Values(2,'1977/02/26')
Insert [TEST] Values(3,'1978/07/05')
Insert [TEST] Values(4,'1979/08/01')
Insert [TEST] Values(5,'1980/07/27')
Insert [TEST] Values(6,'1980/07/25')
GO
--测试
Select * from TEST
Where DateAdd(year,Year(Getdate())-Year(Birthday),Birthday)
Between Convert(Varchar(10),Getdate(),120)
And Convert(Varchar(10),Getdate()+30,120)
--删除测试环境
Drop Table TEST
--结果
/*
IDBirthday
41979/08/01
51980/07/27
61980/07/25
*/