【无标题】

pgsql中{"42883: operator does not exist: timestamp without time zone >= text\r\n\r\报这个错，源代码这样的·后面查各种资料终于，改成这样然后就能把数据分页查询出来了，可是我导出功能也是用的这个sql语句，运行又报错，42883: function to_timestamp(timestamp without time zone, unknown) does not，然后把where条件改成这样就都没有问题了， where ""StartTime"" >=TO_TIMESTAMP(@StartTime::text, 'YYYY-MM-DD HH24:MI:SS')  and ""EndTime"" <=TO_TIMESTAMP(@EndTime::text, 'YYYY-MM-DD HH24:MI:SS')   and ""EquipmentID"" in ({equipmentIdStr}) and ""Recipe"" != 'All'),