Mybatis那一大堆事儿--1

<select id="listAmPerfTime" resultType="Date">
        SELECT pam.perf_time AS perfTime
        FROM perf_ammeter_month AS pam
        WHERE pam.node_id = #{nodeId} AND DATE_FORMAT(pam.perf_time,'-%m-%d %H:%i:%s') = #{perfTimeStr} AND pam.perf_time &lt;= #{perfTime}
    </select>