22,301
社区成员




Select * from data where datediff('d',Now(),[date_time]) >= duration
Select * from data where datediff('Day',Now(),[date_time]) >= duration
--MSSQL
declare @duration int
set @duration = 5
Select * from data where datediff(dd,getdate(),[date_time]) >= duration
datediff('d',Now(),[date_time])