mysql计算工作日的函数

数据运维 2023-08-05 Escape 手机阅读

CREATE FUNCTION working_days(start_date DATE, end_date DATE) RETURNS INT DETERMINISTIC BEGIN DECLARE total_days INT; DECLARE days INT; DECLARE i INT; SET total_days = DATEDIFF(end_date, start_date) + 1; SET days = 0; SET i = 0; WHILE i