Find off days in a date range using mysql
A function to get off days inside mySQL
Copy this code and paste it in your HTML
DELIMITER $$
IF (first_date
< second_date
) THEN SET start_date
= first_date
; SET end_date
= second_date
; SET start_date
= second_date
; SET end_date
= first_date
;
WHILE start_date
<= end_date
DO (dayofweekint < 1)
(CONCAT('[[:<:]]', str_weekends
, '[[:<:]]') REGEXP dayofweekint
)
RETURN diff;
DELIMITER ;
Report this snippet
Comments
Subscribe to comments