This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Just to update the code.SET @start_date = ‘put here the start date’;SET
@end_date = ‘put here the end date’;SET @totaldays = DATEDIFF(@end_date
, @start_date) + 1;SET @saturdays = WEEK(DATE_ADD(@end_date, INTERVAL 2
DAY),3)-WEEK(DATE_ADD(@start_date,...
Code for MARIADB or MYSQLSET @start_date = ‘put here the start date’;SET
@end_date = ‘put here the end date’;SET @totaldays = DATEDIFF(@end_date
, @start_date) + 1;SET @saturdays = WEEK(DATE_ADD(@end_date, INTERVAL 1
DAY))-WEEK(@start_date);SET @sund...