mysql 两日期之间的工作日(除去周六日,不考虑节假日)
select (floor(days/7)*5+days%7
-case when 6 between wd and wd+days%7-1 then 1 else 0 end
-case when 7 between wd and wd+days%7-1 then 1 else 0 end ) INTO str
from
(select datediff(e,s) as days,weekday(s)+1 as wd) as a;
ELSE
select (-(floor(days/7)*5+days%7
-case when 6 between wd and wd+days%7-1 then 1 else 0 end
-case when 7 between wd and wd+days%7-1 then 1 else 0 end) ) into str
from
(select datediff(s,e) as days,weekday(e)+1 as wd) as a;
end if;
RETURN str;
END
select first_func('-11-17','-11-20')
欢迎大家阅读《MYSQL 两日期之间的工作日(去掉周六日,不考虑节假日)_mysql》,跪求各位点评,by 搞代码
微信 赏一包辣条吧~
支付宝 赏一听可乐吧~