sql - 如何在两个日期和月份而不是年份之间获取记录？

Question

I have following records

NAME       BIRTHDATE 
 A         19/09/1990
 B         25/09/1992
 C         26/09/1993

当前日期是 19/09/2014我想获取从当前日期到接下来 7 天的生日记录，下面是我的查询。

CREATE PROCEDURE [dbo].[Get_Birthday]
as
begin
Declare @CurrentDate date ,@NxtDate date

set @CurrentDate = GETDATE(); 
set @NxtDate = DATEADD(day,7,getdate())
print @CurrentDate
print @NxtDate
select DocId, DoctorName,DOA,Email from vw_DoctorDetail 
where DOA between @CurrentDate and @NxtDate
end

Answer 1

你可以试试下面的方法

CREATE PROCEDURE [dbo].[Get_Birthday]
as
beginDeclare @CurrentDate date ,@NxtDate date

set @CurrentDate = DATEADD(year,-DATEDIFF(year,'19000101',GETDATE()),GETDATE()); 
set @NxtDate = DATEADD(day,7,@CurrentDate)
print @CurrentDate
print @NxtDate
select DocId, DoctorName,DOA,Email from vw_DoctorDetail 
WHERE DATEADD(year,-DATEDIFF(year,'19000101',DOA),DOA) between @CurrentDate and @NxtDate