MyBatis查询语句:
字段为datetime类型,传入的参数为date类型,如下所示
查询方法如下
select e.* from table e where e.code = #{meterId, jdbcType=VARCHAR} and DATE_FORMAT(e.collect_time, '%Y-%m-%d %H:%i:%s') = #{collectTime, jdbcType=TIMESTAMP}
MyBatis查询语句:
字段为datetime类型,传入的参数为date类型,如下所示
查询方法如下
select e.* from table e where e.code = #{meterId, jdbcType=VARCHAR} and DATE_FORMAT(e.collect_time, '%Y-%m-%d %H:%i:%s') = #{collectTime, jdbcType=TIMESTAMP}