Get Working day difference for 2 dates
CREATE DEFINER=`root`@`%` FUNCTION `getworkdaydiff`(b date, a date) RETURNS int(11)DETERMINISTICCOMMENT ‘Get Working day difference for 2 dates’BEGINDECLARE freedays int;SET freedays = 0; SET @x = DATEDIFF(b, a);IF @x<0 THENSET @m = a;SET a = b;SET b = @m;SET @m = -1;ELSESET @m = 1;END IF;SET @x = abs(@x) + 1;/* days in first week */SET @w1 […]