MSSQL表中日期如何相减?

Question

select * from archives_manage
where datediff(day,endDate,getdate()) between 0 and 15

Answer 1

SQL中用getdate()函数取得当前日期

Answer 2

select * from archives_manage
where DATEADD(day,-15,endDate)<=getdate()

Answer 3

select * from archives_manage
 where enddate>dateadd(second,-1*datepart(second,dateadd(minute,-1*datepart(minute,dateadd(day,-15,getdate())))