create procedure getweekrange(num int)beginselect x.start,adddate(x.start,6) as end from (select adddate(first,(num-week(first,5))*7-weekday(first)) as start from (select makedate(year(now()),1) as first)t)x; end
本文共 260 字，大约阅读时间需要 1 分钟。
create procedure getweekrange(num int)beginselect x.start,adddate(x.start,6) as end from (select adddate(first,(num-week(first,5))*7-weekday(first)) as start from (select makedate(year(now()),1) as first)t)x; end
转载于:https://www.cnblogs.com/cexm/p/6265849.html