From e13e9e735faafaca5cdaf114ca384b9cbf089cc4 Mon Sep 17 00:00:00 2001 From: lsh <lsh@163.com> Date: 星期二, 15 四月 2025 15:03:37 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java index 62b7596..4946ffd 100644 --- a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java +++ b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java @@ -22,9 +22,9 @@ try { // 鍒犻櫎鍗婂勾浠ヤ笂鐨勫巻鍙叉。 jdbcTemplate.update("delete from asr_stk_hplc where dateadd(day,180,appe_time) <= getdate();"); - jdbcTemplate.update("delete from asr_wrk_detl_log where dateadd(day,360,appe_time) <= getdate();"); - jdbcTemplate.update("delete from asr_wrk_mast_log where dateadd(day,360,appe_time) <= getdate();"); - jdbcTemplate.update("delete from cust_wait_pakin_log where dateadd(day,360,appe_time) <= getdate();"); + jdbcTemplate.update("delete from asr_wrk_detl_log where dateadd(day,1080,appe_time) <= getdate();"); + jdbcTemplate.update("delete from asr_wrk_mast_log where dateadd(day,1080,appe_time) <= getdate();"); + jdbcTemplate.update("delete from cust_wait_pakin_log where dateadd(day,1080,appe_time) <= getdate();"); } catch (Exception e) { e.printStackTrace(); -- Gitblit v1.9.1