Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/UrgentNeedGoodsProcessingCycleHelper.java =================================================================== diff -u -r37224 -r37240 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/UrgentNeedGoodsProcessingCycleHelper.java (.../UrgentNeedGoodsProcessingCycleHelper.java) (revision 37224) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/UrgentNeedGoodsProcessingCycleHelper.java (.../UrgentNeedGoodsProcessingCycleHelper.java) (revision 37240) @@ -75,7 +75,7 @@ String tousseTypesSql = SqlUtils.getWhereSqlByfilterFieldAndStringValueAndSeparatorFilterAll("temp.tousseType", tousseTypes, ","); String datediffWashTime = null; if(dbConnection.isOracle()){ - datediffWashTime = "EXTRACT(DAY FROM (wrwashTime.endDate - wrwashTime.startDate)) * 24 + EXTRACT(HOUR FROM (wrwashTime.endDate - wrwashTime.startDate)) * 60 + EXTRACT(MINUTE FROM (wrwashTime.endDate - wrwashTime.startDate))"; + datediffWashTime = "EXTRACT(DAY FROM (max(wrwashTime.endDate) - max(wrwashTime.startDate))) * 24 + EXTRACT(HOUR FROM (max(wrwashTime.endDate) - max(wrwashTime.startDate))) * 60 + EXTRACT(MINUTE FROM (max(wrwashTime.endDate) - max(wrwashTime.startDate)))"; }else{ datediffWashTime = "DATEDIFF(MINUTE,max(wrwashTime.startDate),max(wrwashTime.endDate))"; }