Mybatis那一大堆事儿--1

limeOracle

于 2016-11-01 19:14:00 发布

阅读量66

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/limeOracle/article/details/100570295

<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>