From b82dd656696408e3cb5ea9a96cfb00e8a5f1bde8 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 07 Mar 2024 11:04:13 +0800
Subject: [PATCH] 时间格式修改

---
 skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/alarmRule/mapper/AlarmRecordMapper.xml |    8 ++++----
 1 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/alarmRule/mapper/AlarmRecordMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/alarmRule/mapper/AlarmRecordMapper.xml
index 4839e1b..d029059 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/alarmRule/mapper/AlarmRecordMapper.xml
+++ b/skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/alarmRule/mapper/AlarmRecordMapper.xml
@@ -42,10 +42,10 @@
             and sar1.rule_name = #{alarmRecord.ruleName}
         </if>
         <if test="alarmRecord.startTime!=null and alarmRecord.startTime!=''">
-            and date_format(sar.create_time,'%Y-%m-%d') >= #{alarmRecord.startTime}
+            and sar.create_time >= #{alarmRecord.startTime}
         </if>
         <if test="alarmRecord.endTime!=null and alarmRecord.endTime!=''">
-            and date_format(sar.create_time,'%Y-%m-%d') &lt;= #{alarmRecord.endTime}
+            and sar.create_time &lt;= #{alarmRecord.endTime}
         </if>
         <if test="alarmRecord.adCode!=null and alarmRecord.adCode!=''">
             and  a."interior_ad_guid" like concat('%',#{alarmRecord.adCode},'%')
@@ -121,10 +121,10 @@
                 and e.rule_name = #{alarmRecord.ruleName}
             </if>
             <if test="alarmRecord.startTime!=null and alarmRecord.startTime!=''">
-                and date_format(sar.create_time,'%Y-%m-%d') >= #{alarmRecord.startTime}
+                and sar.create_time >= #{alarmRecord.startTime}
             </if>
             <if test="alarmRecord.endTime!=null and alarmRecord.endTime!=''">
-                and date_format(sar.create_time,'%Y-%m-%d') &lt;= #{alarmRecord.endTime}
+                and sar.create_time &lt;= #{alarmRecord.endTime}
             </if>
             <if test="alarmRecord.adCode!=null and alarmRecord.adCode!=''">
                 and arb."interior_ad_guid" like concat('%',#{alarmRecord.adCode},'%')

--
Gitblit v1.9.3