EodProcessLog to DatewiseProcessExecution

INSERT INTO profino_rbl.datewise_process_execution
(bank_name, execution_completion_time, execution_date, execution_starting_time, is_executed, service_name, note, date_of_execution)
SELECT l.bank_name, l.end_time, date_format(l.date_for_report, '%d-%m-%Y'), l.start_time, (CASE status WHEN 'SUCCESS' THEN TRUE ELSE FALSE END ), process_name, note, date_for_report FROM eod_process_log l
WHERE l.process_name = 'dailySummaryReport'
AND Date(l.date_for_report) > '2017-01-01 00:00:00'
;