mysql

日期等于：

<if test="mallDate != null "> and date_format(mall_date, '%Y-%m-%d') = date_format(#{mallDate},'%Y-%m-%d')</if>