問題描述:
ERROR: operator does not exist: timestamp without time zone > character varying
解決方法:
//注意此處的格式必須是 yyyy-mm-dd hh:mm:ss[.f...] 這樣的格式坠陈,中括號表示可選食零,否則報(bào)錯(cuò)
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>