Index: ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/service/WashAndDisinfectRecordManagerImpl.java
===================================================================
diff -u -r28005 -r28083
--- ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/service/WashAndDisinfectRecordManagerImpl.java	(.../WashAndDisinfectRecordManagerImpl.java)	(revision 28005)
+++ ssts-wash/src/main/java/com/forgon/disinfectsystem/washanddisinfectmanager/washanddisinfectrecord/service/WashAndDisinfectRecordManagerImpl.java	(.../WashAndDisinfectRecordManagerImpl.java)	(revision 28083)
@@ -3265,7 +3265,7 @@
 			return washData;
 		} else if(dbConnection.isOracle()){
 			String whereSql = String.format(
-					" where po.deviceInterfaceID = %s and  po.machineNo = '%s' and po.startedDateTime >= to_date('%s','yyyy-mm-dd hh24:mi:ss') and po.completedTime <= to_date('%s','yyyy-mm-dd hh24:mi:ss') order by po.id desc ",
+					" where po.deviceInterfaceID = %s and  po.machineNo = '%s' and po.startedDateTime >= to_date('%s','yyyy-mm-dd hh24:mi:ss') and po.completedTime <= '%s' order by po.id desc ",
 					deviceInterfaceId, machineNo, wdr.getStartDateStr(), wdr.getEndDateStr());
 			WashDataOfChangLong washData = (WashDataOfChangLong) objectDao.getBySql(WashDataOfChangLong.class.getSimpleName(), whereSql);
 			return washData;