1、SQL2000中一表有一日期型字段BirthDay,记录出生日期,想每年在本日生日前15天,将其过滤出来,怎么写Where条件?:
select out_date from sales_out_head_tab where (DATEDIFF(day,DATEADD(year ,year(getdate())-year(out_date) ,out_date )
,getdate()) BETWEEN -15 and 0 ) order by out_date
1、SQL2000中一表有一日期型字段BirthDay,记录出生日期,想每年在本日生日前15天,将其过滤出来,怎么写Where条件?:
select out_date from sales_out_head_tab where (DATEDIFF(day,DATEADD(year ,year(getdate())-year(out_date) ,out_date )
,getdate()) BETWEEN -15 and 0 ) order by out_date