mysql date的写法_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

ar.detail_voucher_id is NULL and ar.submit_regulatory_status = 5

AND ar.recharge_account_type = #{rechargeAccountType}

AND ar.recharge_mode = #{rechargeMode}

AND Date(ar.pay_finish_time) = #{payFinishTime}

ORDER BY ar.create_date

分享到：

2018-03-20 15:43

浏览 778

评论