2023年法定假日+公休(去除工作日)数据库sql

最新推荐文章于 2024-05-01 19:17:00 发布

@幻影忍者

最新推荐文章于 2024-05-01 19:17:00 发布

阅读量1.6k

点赞数

分类专栏：数据库文章标签： java 数据库

本文链接：https://blog.csdn.net/zw899004/article/details/128544202

版权

数据库专栏收录该内容

11 篇文章 0 订阅

订阅专栏

INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230101', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230102', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230107', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230108', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230114', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230115', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230121', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230122', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230123', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230124', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230125', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230126', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230127', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230204', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230205', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230211', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230212', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230218', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230219', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230225', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230226', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230304', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230305', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230311', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230312', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230318', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230319', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230325', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230326', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230401', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230402', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230405', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230408', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230409', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230415', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230416', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230422', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230429', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230430', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230501', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230502', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230503', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230507', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230513', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230514', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230520', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230521', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230527', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230528', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230603', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230604', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230610', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230611', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230617', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230618', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230622', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230623', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230624', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230701', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230702', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230708', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230709', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230715', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230716', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230722', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230723', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230729', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230730', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230805', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230806', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230812', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230813', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230819', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230820', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230826', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230827', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230902', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230903', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230909', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230910', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230916', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230917', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230923', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230924', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230929', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20230930', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231001', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231002', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231003', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231004', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231005', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231006', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231014', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231015', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231021', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231022', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231028', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231029', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231104', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231105', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231111', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231112', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231118', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231119', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231125', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231126', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231202', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231203', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231209', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231210', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231216', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231217', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231223', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231224', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231230', '1');
INSERT INTO "HOLIDAY_DATA"("HOLIDAY_DATE", "HOLIDAY_TYPE") VALUES ('20231231', '1');