2025年节假日sql oracle_2025年日历数据初始化到数据库-CSDN博客

本文链接：https://blog.csdn.net/qq_38190509/article/details/143735727

DAY_TYPE ：1工作日，2周末，3节假日

INSERT INTO T_HOLIDAY_CONFIG
  (DAY_YMD, DAY_TYPE)
  SELECT DAY_YMD,
         CASE
           WHEN DAY_YMD IN
                ('2025-01-01', '2025-01-28', '2025-01-29', '2025-01-30',
                 '2025-01-31', '2025-02-01', '2025-02-02', '2025-02-03',
                 '2025-02-04', '2025-04-04', '2025-04-05', '2025-04-06',
                 '2025-05-01', '2025-05-02', '2025-05-03', '2025-05-04',
                 '2025-05-05', '2025-05-31', '2025-06-01', '2025-06-02',
                 '2025-10-01', '2025-10-02', '2025-10-03', '2025-10-04',
                 '2025-10-05', '2025-10-06', '2025-10-07', '2025-10-08') THEN
            '3'
           WHEN DAY_YMD IN ('2025-02-08', '2025-04-27', '2025-09-28',
                 '2025-10-11') THEN
            '1'
           ELSE
            DAY_TYPE
         END DAY_TYPE
    FROM (SELECT DAY_YMD,
                 CASE
                   WHEN TRIM(TO_CHAR(TO_DATE(DAY_YMD, 'yyyy-MM-dd'), 'day')) IN
                        ('星期六', '星期日') THEN
                    '2'
                   ELSE
                    '1'
                 END DAY_TYPE
            FROM (SELECT TO_CHAR(TO_DATE('2025-01-01', 'yyyy-MM-dd') + ROWNUM - 1,
                                 'yyyy-MM-dd') AS DAY_YMD
                    FROM DUAL
                  CONNECT BY ROWNUM <=
                             TRUNC(TO_DATE('2025-12-31', 'yyyy-MM-dd') -
                                   TO_DATE('2025-01-01', 'yyyy-MM-dd')) + 1));