判断工作日
select min(v_date) as minv_date from (
select DATE_ADD('2026-08-13', INTERVAL num DAY) as v_date from (
select 0 as num union all
select 1 as num union all
select 2 as num union all
select 3 as num union all
select 4 as num union all
select 5 as num union all
select 6 as num union all
select 7 as num union all
select 8 as num union all
select 9 as num union all
select 10 as num union all
select 11 as num ) as nummmm) as tttt
where
DAYOFWEEK(v_date) NOT IN (1, 7)
and NOT ((v_date BETWEEN '2026-01-01' AND '2026-01-03') -- 元旦
OR (v_date BETWEEN '2026-02-15' AND '2026-02-23') -- 春节
OR (v_date BETWEEN '2026-04-04' AND '2026-04-06') -- 清明节
OR (v_date BETWEEN '2026-05-01' AND '2026-05-05') -- 劳动节
OR (v_date BETWEEN '2026-06-19' AND '2026-06-21') -- 端午节
OR (v_date BETWEEN '2026-09-25' AND '2026-09-27') -- 中秋节
OR (v_date BETWEEN '2026-10-01' AND '2026-10-07') -- 国庆节
)
-- 上交所