UPDATE ASDK_SERVICE_CALL SET serv_colsed_date = serv_solution_real_Date +1 WHERE serv_opened_date BETWEEN TO_DATE('01-01-2016 01:00:00', 'DD-MM-YY HH:MI:SS') AND TO_DATE('31-12-2016 06:00:00', 'DD-MM-YY HH:MI:SS') AND SERV_COLSED_DATE is NULL commit; UPDATE ASDK_INCIDENT SET inci_colsed_date = inci_solution_real_Date +1 WHERE inci_opened_date BETWEEN TO_DATE('01-01-2016 01:00:00', 'DD-MM-YY HH:MI:SS') AND TO_DATE('31-12-2016 06:00:00', 'DD-MM-YY HH:MI:SS') AND inci_COLSED_DATE is NULL commit;