某个时间对应的下一个工作日十点写法

zy_day 表结构，day_num每天的日期，type = 'W' 工作日，type = 'W'假期

SELECT day_num, DATE_FORMAT(wdn.end_date, '%Y-%m-%d 10:00:00') 下一个工作日十点 FROM zy_day t LEFT JOIN ( SELECT a.day_num AS start_date, MIN(b.day_num) AS end_date FROM zy_day a JOIN zy_day b ON a.day_num < b.day_num WHERE b.type = 'W' GROUP BY a.day_num) wdn ON DATE(t.day_num) = wdn.start_date WHERE DATE(t.day_num) = DATE('2025-04-30 15:45:05');