SQL：提前七天提醒

最新推荐文章于 2025-08-02 02:13:58 发布

ZHOU_VIP

最新推荐文章于 2025-08-02 02:13:58 发布

阅读量735

点赞数

CC 4.0 BY-SA版权

分类专栏： Orale MySQL 文章标签： SQL

本文链接：https://blog.youkuaiyun.com/ZHOU_VIP/article/details/53505728

Orale MySQL 专栏收录该内容

73 篇文章

订阅专栏

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

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