Mysql 日期大小比较

六月的雨在Tencent

发布于 2024-03-28 21:02:19

13700

代码可运行

文章被收录于专栏：CSDNCSDN

运行总次数：0

代码可运行

Mysql 日期大小比较

mysql 时间参数年月日时分秒比较大小

    <select id="checkTimeRepeatNum" parameterType="HomepageAdvertisement" resultType="int">
        SELECT COUNT(*) FROM qs_study_homepage_advertisement WHERE is_valid=1
        <if test="id != null "> and id != #{id}</if>
        <if test="examId != null "> AND exam_id = #{examId}</if>
        <if test="year != null "> AND year = #{year}</if>
        AND DATE_FORMAT(#{paramTime},'%Y-%m-%d %T') >= DATE_FORMAT(start_time,'%Y-%m-%d %T')
        AND DATE_FORMAT(end_time,'%Y-%m-%d %T') >= DATE_FORMAT(#{paramTime},'%Y-%m-%d %T')
    </select>

mysql 时间参数年月日比较大小

    <select id="selectLatelyUserDayScheduleByUserExtendId" resultMap="UserDayScheduleResult">
        <include refid="selectUserDayScheduleVo"/>
        WHERE user_extend_id = #{userExtendId} AND is_valid=1
        AND DATE(schedule_date) >= DATE(#{nowDate}) ORDER BY schedule_date ASC LIMIT 1
    </select>

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2024-03-28，如有侵权请联系 cloudcommunity@tencent.com 删除

select