Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/InstrumentSetDemandReportHelper.java =================================================================== diff -u -r41494 -r41507 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/InstrumentSetDemandReportHelper.java (.../InstrumentSetDemandReportHelper.java) (revision 41494) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/InstrumentSetDemandReportHelper.java (.../InstrumentSetDemandReportHelper.java) (revision 41507) @@ -106,7 +106,9 @@ SqlUtils.checkInputParam(queryDepart); SqlUtils.checkInputParam(queryTousseName); StringBuilder sql = new StringBuilder(); - sql.append("SELECT CONVERT(DATE, o.operationTime) operationTime, ip.depart, ti.tousseName, ") + sql.append("SELECT ") + .append(dateQueryAdapter.dateToVarchar1("o.operationTime")) + .append(" operationTime, ip.depart, ti.tousseName, ") .append("o.operationName, ti.amount, ip.id ipId ") .append("FROM OperationReservation o ") .append("JOIN invoicePlan ip ON ip.id = o.id ")