mysql的 日期格式化

http://www.w3school.com.cn/sql/func_date_format.asp

SELECT count(*)
FROM (SELECT
        a.PKID,
        a.SERIAL_NO,
        a.PAY_ORDER_NO,
        a.PAY_TRADE_NO,
        a.AMOUNT,
        a.IN_ACCOUNT,
        a.RECORD_TIME,
        a.TRADE_TIME,
        a.SETTLE_TIME,
        a.DESCRIPTION,
        a.CREATE_TIME
      FROM advance_bill a
      WHERE DATE_FORMAT(a.TRADE_TIME,'%Y%m%d') = '20170607') t

<select id="select" parameterClass="java.util.HashMap" resultMap="advanceBillMap">
    select
        a.PKID,a.SERIAL_NO,a.PAY_ORDER_NO,a.PAY_TRADE_NO,a.AMOUNT,a.IN_ACCOUNT,a.RECORD_TIME,
        a.TRADE_TIME,a.SETTLE_TIME,a.DESCRIPTION,a.CREATE_TIME
    from  advance_bill a
    <dynamic prepend="where">
        <include refid="dynamicWhere" />
    </dynamic>
    <dynamic prepend="order by">
        <isNotEmpty property="fieldSort">$fieldSort$</isNotEmpty>
    </dynamic>
</select>

<sql id="dynamicWhere">
    <isNotEmpty prepend="and" property="queryTime">
        DATE_FORMAT(a.TRADE_TIME,'%Y%m%d') = #queryTime#
    </isNotEmpty>
    <isNotEmpty prepend="and" property="serialNo">
        a.SERIAL_NO = #serialNo#
    </isNotEmpty>
    <isNotEmpty prepend="and" property="payOrderNo">
        a.PAY_ORDER_NO = #payOrderNo#
    </isNotEmpty>
</sql>

这样就可以在mybatis的 xml中 很方便的处理String类型的时间参数 和 DATA类型的数据库字段了