SQL：提前七天提醒

保险的止保日期快到了，需要提前七天提醒，关键条件是：

sysdate < t.SECURE_END_TIME and t.SECURE_END_TIME < sysdate + 7


select t.RECORD_ID as recordId,
       t.HOST_ID as hostId,
       t.HOST_NO as carHostNO,
       t.SECURE_PAY as securePay,
       to_char(t.SECURE_END_TIME, 'yyyy-mm-dd') as secureEndTime,
       po.APPSYSID as appSysId,
       po.APPDEPTID as appDeptId
from CAR_SECURE t, POSITION_HOST_INFO po
where t.host_id = po.hostid
and ((po.appsysid, po.appdeptid) in
     (select appsysid, appdeptid from table(get_subdept(-1, 2000, 0))))
and sysdate < t.SECURE_END_TIME
and t.SECURE_END_TIME < sysdate + 7