PostgreSql问题：ERROR:operatordoesnotexist:timestampwithouttimezone>charactervarying

问题描述：

ERROR:  operator does not exist: timestamp without time zone > character varying

解决方法：

//注意此处的格式必须是 yyyy-mm-dd hh:mm:ss[.f&＃8230;] 这样的格式，中括号表示可选，否则报错

Timestamp alarmStartTime = Timestamp.valueOf(&＃8220;2011-05-09 11:49:45&＃8221;);

Timestamp alarmEndTime = Timestamp.valueOf(&＃8220;2011-05-09 11:49:45&＃8220;);

condition.put(&＃8220;alarmStartTime&＃8221;, alarmStartTime);
condition.put(&＃8220;alarmEndTime&＃8221;, alarmEndTime);

AND alarm_start_time > #{alarmStartTime}


AND alarm_end_time <#{alarmEndTime}