diff --git a/casic-metering-dao/src/main/resources/mapper/meter/MeterCertificateMapper.xml b/casic-metering-dao/src/main/resources/mapper/meter/MeterCertificateMapper.xml
index 213f913..3230a3e 100644
--- a/casic-metering-dao/src/main/resources/mapper/meter/MeterCertificateMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/meter/MeterCertificateMapper.xml
@@ -68,10 +68,10 @@
             <if test="request.certificateStatus != null  and request.certificateStatus != ''">
 <!--                and t1.certificate_status = #{request.certificateStatus}-->
                 <if test="request.certificateStatus == 0">
-                    and NOW() &lt; t1.valid_date
+                    and curdate() &lt; t1.valid_date
                 </if>
                 <if test="request.certificateStatus == 1">
-                    and NOW() &gt; t1.valid_date
+                    and curdate() &gt; t1.valid_date
                 </if>
             </if>
             <if test="request.remindType == 'remind' ">