mySql 时间间隔
select *
from node_complex_alarm
where INPUTTIME BETWEEN (select DATE_ADD(Now(),INTERVAL -30 day)) and (select NOW())
Sql 时间间隔
select * from DA_ARRIVE_RECENT where ARRIVE_DATETIME BETWEEN (DATEADD(DAY, -20, (select GETDATE()))) and (select GETDATE())