<if test="start != null">
AND created_time >= date_format(#{start},'%Y-%c-%d 00:00:00')
</if>
<if test="end != null">
AND created_time <= date_format(#{end},'%Y-%c-%d 23:59:59')
</if>
按照日期的开始日期和结束日期进行查询
![](https://img-home.csdnimg.cn/images/20240711042549.png)