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 appDeptIdfrom CAR_SECURE t, POSITION_HOST_INFO powhere t.host_id = po.hostidand ((po.appsysid, po.appdeptid) in     (select appsysid, appdeptid from table(get_subdept(-1, 2000, 0))))and sysdate < t.SECURE_END_TIMEand t.SECURE_END_TIME < sysdate + 7