判断工作日 - yongqi

判断工作日

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') -- 国庆节

)

 -- 上交所

• 休市安排  https://www.sse.com.cn/disclosure/dealinstruc/closed/