mysql 开始-结束时间参数匹配表中startTime、endTime字段范围内记录

KK_AN_SS

已于 2023-11-20 09:20:07 修改

阅读量329

点赞数

文章标签： mysql

于 2023-04-18 09:38:06 首次发布

本文链接：https://blog.csdn.net/miaohemi/article/details/130213693

版权

<if test="kssj != null and kssj != '' and jssj != null and jssj != ''">
       AND    
            (
            (startTime <= #{jssj} AND endTime >= #{kssj} AND startTime >= endTime
            )
</if>

<!-- 或者下面这种格式 -->

<if test="kssj != null and kssj != '' and jssj != null and jssj != ''">
       AND    
            (
            (startTime BETWEEN #{kssj} AND #{jssj})
            OR (endTime BETWEEN #{kssj} AND #{jssj})
            OR (startTime &lt;= #{kssj} AND endTime >= #{jssj})
            OR (startTime >= #{kssj} AND endTime &lt;= #{jssj})
            )
</if>