From bf323bef9d9e5c5e91afd637fcd39f49d8bacbea Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 19 三月 2025 10:04:07 +0800
Subject: [PATCH] 语法适配瀚高

---
 src/main/resources/mapper/BattLithiumTestDataInfMapper.xml |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/src/main/resources/mapper/BattLithiumTestDataInfMapper.xml b/src/main/resources/mapper/BattLithiumTestDataInfMapper.xml
index be3e2d0..e05e324 100644
--- a/src/main/resources/mapper/BattLithiumTestDataInfMapper.xml
+++ b/src/main/resources/mapper/BattLithiumTestDataInfMapper.xml
@@ -62,7 +62,7 @@
         select num,dev_id,test_type,floor(dev_id/100000000) as dev_type,DATE_FORMAT(test_starttime, '%Y-%m-%d') AS week_day
         from db_lithium_testdata.tb_batttestdata_inf
         <where>
-            DATE_SUB(CURDATE(), INTERVAL 6 DAY) &lt;= DATE(test_starttime)
+            (CURRENT_DATE - INTERVAL '6 day') &lt;= DATE(test_starttime)
             and floor(dev_id/100000000)=#{type}
             and dev_id in (
             SELECT distinct dev_id from db_user.tb_battgroup_baojigroup,db_user.tb_battgroup_usr

--
Gitblit v1.9.1