时间:2021-07-01 10:21:17 帮助过:249人阅读
//注意此处的格式必须是 yyyy-mm-dd hh:mm:ss[.f...] 这样的格式,中括号表示可选,否则报错
Timestamp alarmStartTime = Timestamp.valueOf("2011-05-09 11:49:45");
Timestamp alarmEndTime = Timestamp.valueOf("2011-05-09 11:49:45");
condition.put("alarmStartTime", alarmStartTime);
condition.put("alarmEndTime", alarmEndTime);
<if test="alarmStartTime!=null && alarmStartTime!=‘‘">
AND alarm_start_time > #{alarmStartTime}
</if>
<if test="alarmEndTime!=null && alarmEndTime!=‘‘">
AND alarm_end_time < #{alarmEndTime}
</if>
PostgreSql问题:ERROR: operator does not exist: timestamp without time zone > character varying
标签:end back erro round alarm postgre tor not start