语法适配瀚高

whycxzp

2025-03-19 bf323bef9d9e5c5e91afd637fcd39f49d8bacbea

语法适配瀚高

 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