Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java =================================================================== diff -u -r38574 -r38616 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 38574) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 38616) @@ -290,12 +290,12 @@ //回收开始时间ZSRY-84 String recyclingTimeStart = sqlWhereParamMap.get("recyclingTimeStart"); if(StringUtils.isNotBlank(recyclingTimeStart)){ - sqlBuilder.append(String.format(" AND po.recyclingTime >= %s ",parseStartTime(recyclingTimeStart,true))); + sqlBuilder.append(String.format(" AND po.recyclingTime >= '%s' ",parseStartTime(recyclingTimeStart,false))); } //回收结束时间ZSRY-84 String recyclingTimeEnd = sqlWhereParamMap.get("recyclingTimeEnd"); if(StringUtils.isNotBlank(recyclingTimeEnd)){ - sqlBuilder.append(String.format(" AND po.recyclingTime < %s ",parseStartTime(recyclingTimeEnd,true))); + sqlBuilder.append(String.format(" AND po.recyclingTime < '%s' ",parseStartTime(recyclingTimeEnd,false))); } //过滤条件:灭菌