PROCEDURE abc(pmId INT, dateFrom DATE, dateTo DATE)BEGIN DECLARE str TEXT; DECLARE dff DATETIME; DECLARE dnn DATETIME; DECLARE dn DATE; DECLARE df DATE; SET df = dateFrom; WHILE DATE(df) <= DATE(dateTo) DO SET dn = DATE_ADD(df, INTERVAL 1 DAY); SET dff = CONCAT(df, ‘ 08:00:00′); SET dnn = CONCAT(dn, ‘ 07:59:00′); [...]
