SQL查询当天范围内的数据

码农_憨憨 ௹

于 2025-03-20 19:23:26 发布

阅读量157

点赞数 3

CC 4.0 BY-SA版权

文章标签： sql mybatis 数据库

本文链接：https://blog.csdn.net/weixin_54063136/article/details/146404259

<select id="getClockTodayList" resultMap="clockResultMap">
        SELECT *
        FROM sys_user_work_clock
        WHERE is_deleted = 0
        <if test="userId != null and userId != ''">
            AND user_id = #{userId}
        </if>
        <if test="clockType != null and clockType != ''">
            AND clock_type = #{clockType}
        </if>
        -- 筛选 clock_time 在当天的记录
        AND clock_time <![CDATA[ >= ]]> DATE_FORMAT(NOW(), '%Y-%m-%d 00:00:00')
        AND clock_time <![CDATA[ <= ]]> DATE_FORMAT(NOW(), '%Y-%m-%d 23:59:59')
    </select>