查询有带时间条件时:
CAST:格式转换
DATE:不带时分秒的时间格式
<if test="dto.createdDate != null">
and CAST(created_date AS DATE)=CAST(#{dto.createdDate} AS DATE)
</if>
查询有带时间条件时:
CAST:格式转换
DATE:不带时分秒的时间格式
<if test="dto.createdDate != null">
and CAST(created_date AS DATE)=CAST(#{dto.createdDate} AS DATE)
</if>