查询某日期段之间的生日（考虑跨年）

--查询某日期段之间的生日 DECLARE @STARTTIME DATETIME SET @STARTTIME='开始日期' DECLARE @ENDTIME DATETIME SET @ENDTIME='截止日期' SELECT * FROM TB WHERE (DATEADD(YEAR,DATEDIFF(YEAR,BIRTHDAY,@STARTTIME),BIRTHDAY) BETWEEN @STARTTIME AND CASE WHEN DATEDIFF(YEAR,@STARTTIME,@ENDTIME)=0 THEN @ENDTIME ELSE DATEADD(YEAR,DATEDIFF(YEAR,'19001231',@STARTTIME),'19001231') END) OR (DATEADD(YEAR,DATEDIFF(YEAR,BIRTHDAY,@ENDTIME),BIRTHDAY) BETWEEN CASE WHEN DATEDIFF(YEAR,@STARTTIME,@ENDTIME)=0 THEN @ENDTIME ELSE DATEADD(YEAR,DATEDIFF(YEAR,'19000101',@ENDTIME),'19000101') END AND @ENDTIME)