mysql 对日期的写法 mybatis

引用

字段截日期来等于 传入的日期类型
Date(ar.pay_finish_time) = #{payFinishTime}

字段值是 时间到小时分， 把它格式化下 ， 并把传入的string值跟它比较

where date_format(pay_finish_time, '%Y-%m-%d') = date_format(#{accountingDateStr},'%Y-%m-%d')

SELECT ar.recharge_id,ar.recharge_amount,ar.bind_pay_channel,ar.pay_finish_time,ar.account_id
        FROM fm_account_recharge ar
        <where>
            ar.detail_voucher_id is NULL and ar.submit_regulatory_status = 5
            <if test="rechargeAccountType != '' and rechargeAccountType != null">AND ar.recharge_account_type = #{rechargeAccountType}</if>
            <if test="rechargeMode != '' and rechargeMode != null">AND ar.recharge_mode = #{rechargeMode}</if>
            <if test="payFinishTime != null">AND Date(ar.pay_finish_time) = #{payFinishTime}</if>
        </where>
        ORDER BY ar.create_date