按照日期的开始日期和结束日期进行查询

        <if test="start != null">
            AND created_time &gt;= date_format(#{start},'%Y-%c-%d 00:00:00')
        </if>
        <if test="end != null">
            AND created_time &lt;= date_format(#{end},'%Y-%c-%d 23:59:59')
        </if>