CREATE FUNCTION `get_times_weeek` ( last_accting_date DATETIME, nursePerformTime VARCHAR (50) ) RETURNS INT (11) COMMENT '计算以周为单位的计费次数' BEGIN DECLARE return_val INT DEFAULT 0 ; DECLARE flag BOOLEAN DEFAULT FALSE ; DECLARE weekNo INT ; DECLARE s_index INT ; IF last_accting_date IS NOT NULL
&&
DATE_FORMAT(NOW(), '%Y-%m-%d') = DATE_FORMAT(last_accting_date, '%Y-%m-%d') THEN SET return_val = 0 ; ELSE SELECT DAYOFWEEK(NOW()) INTO weekNo ; IF weekNo = 1 THEN SET weekNo = 7 ; ELSE SET weekNo = weekNo - 1 ; END IF ; SELECT LOCATE(weekNo, nursePerformTime) INTO s_index ; IF
转载请注明原文地址: https://www.6miu.com/read-51267.html
