2024年法定节假日数据库sql配置

于 2023-12-28 10:40:25 发布
阅读量826 收藏 9
点赞数 10
分类专栏： Oracle 文章标签： 数据库 sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40563534/article/details/135263403
版权

字段说明：

day_typ：工作日：0; 法定节假日：1; 休息日加班：2; 休息日 ：3

wk_Day: 日期
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-01-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-01-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-01-31 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-02-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-02-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-02-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-02-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-02-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-02-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-02-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-03-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-03-31 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-04-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-04-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-04-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-04-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-04-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-04-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-04-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-04-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-04-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-04-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-04-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-05-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-05-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-05-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-05-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-05-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-05-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-05-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-05-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-05-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-05-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-05-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-05-31 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-06-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-06-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-06-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-06-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-06-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-07-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-07-31 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-08-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-08-31 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-09-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-09-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-09-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-09-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-09-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-09-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-09-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-09-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-09-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-09-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-09-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-09-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-10-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-10-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-10-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-10-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-10-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-10-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('1','2024-10-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('2','2024-10-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-10-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-10-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-10-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-10-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-10-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-10-31 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-11-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-11-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-01 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-02 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-03 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-04 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-05 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-06 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-07 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-08 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-09 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-10 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-11 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-12 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-13 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-14 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-15 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-16 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-17 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-18 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-19 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-20 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-21 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-22 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-23 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-24 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-25 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-26 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-27 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-28 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('3','2024-12-29 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-30 00:00:00');
INSERT INTO `t_pub_wkday` (`day_typ`, `wk_day`) VALUES('0','2024-12-31 00:00:00');

qq_40563534
关注
  • 10
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
专栏目录
2020 年全年详细工作日、周末、节假日数据表（SQL）
12-04
2020年最详细日期数据表，数据表包含2020年每个日期对应的节假日类型（工作日，节假日，周末），导入即可
2020年节假日数据库文件
01-21
1、接口地址：http://api.goseek.cn/Tools/holiday?date=数字日期 2、返回数据：正常工作日对应结果为 0, 法定节假日对应结果为 1, 节假日调休补班对应的结果为 2，休息日对应结果为 3  3、节假日数据说明：本接口包含2017年起的中国法定节假日数据，数据来源国务院发布的公告，每年更新1次，确保数据最新 4、示例： http://api.goseek.cn/Tools/holiday?date=20170528 返回数据：
数据库增加2024年所有法定节假日并去除调休SQL
青及笄经验分享
11-29 1845
在数据库中根据国家规定增加对应日期的调休，即周末也可能为工作日的情况，本次操作执行参考2024年所有调休以及法定节假日（包含双休），使用sql插入数据，有需要可以根据以下SQL进行调整。在很多业务场景中，需要特殊考虑到一些特殊的法定节假日，这些日期在实际对的业务逻辑中需要特殊计算，所以就需要在对应的库表中增加对应的日期记录，在实际操作时进行绕过。以下为插入所有节假日的日期的sql。
2019节假日.sql
08-12
2019节假日数据库脚本 包括创建表结构 整理2019年所有节假日数据库脚本
2020年-2023年节假日明细表(可导入数据库)
12-06
2020年-2023年节假日明细表，包括日期、节假日类型等字段，可直接导入SQL server等数据库使用
2024年 节假日 sql (0.工作日 1周末休息 2节假日)
xiaocui_hot的博客
11-30 978
ENGINE=InnoDB AUTO_INCREMENT=1096 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统节假日数据';`day_type` int(4) DEFAULT '0' COMMENT '类型 0.工作日 1周末休息 2节假日 ',`day_day` int(11) DEFAULT NULL COMMENT '时间 年月日',
2023年法定假日+公休(去除工作日)数据库sql
zw899004的专栏
01-04 1647
2023年法定假日+公休(去除工作日)数据库sql
2022年国家法定节假日sql;2022节假日表;最新节假日表;不能用你打我
05-12
2022年节假日mysql语句,2022节假日表,最新节假日表; =============================================== DROP TABLE IF EXISTS `t_pub_wkday`; CREATE TABLE `t_pub_wkday`  (   `wk_Day` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日期；',   `day_Typ` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '（工作日：0;     法定节假日：1;      休息日加班：2;       休息日 ：3;）' ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
2023年-2024年节假日明细表(可导入数据库)
最新发布
01-15
2023年-2024年节假日明细表(可导入数据库)
2021法定节假日(sql版).xlsx
01-11
由于项目需要判断节假日，自己根据2021年的节假日整理出了这份表。列有：日期、星期、工作日\节假日\补班类型、节假日备注。带有sql语句，可直接导入oracle数据库。也可以修改一下语句导入到SqlServer、MySQL中。
2017-2020法定节假日数据和SQL
10-06
2017-2020法定节假日数据和SQL，0为正常工作日，2为调休工作日，1、3为节假日，SQL : INSERT INTO "dmvbi"."pmhc_work_time" VALUES ('20170101', '3', NULL, '7', '2020-09-25 18:34:03.220521');
2002年至2022年国家法定节假日含调休日数据库
12-03
2002年至2022年国家法定节假日含调休日数据库
2019节假日数据库表sql文件下载
02-28
2019节假日数据库表sql文件下载。 该sql文件为 2019年万年历工作日节假日数据库表，节假日总共为115天 2019节假日
2023年所有节假日汇总数据库
12-29
2023年所有节假日（春节、元旦、劳动节、端午、国庆节等传统节日）汇总（含周末） 使用方法： 直接在sql工具中执行，nactive for mysql 中执行效果更佳
2022年法定节假日.sql
11-16
2022年法定节假日
2022年日历最全法定节假日SQL，可直接使用。Oracle/Mysql
04-09
被骗了几个币后，自己写吧。可以直接使用的日历，法定节假日SQL。稍作修改，可以用于其他年份。
Intouch的SQL数据库配置
01-27
Intouch的SQL数据库配置
2024年法定假日加周末sql脚本
weixin_43844575的博客
11-14 807
('清明节','2024-04-04','法定节假日'),('清明节','2024-04-05','法定节假日'),('劳动节','2024-05-01','法定节假日'),('劳动节','2024-05-02','法定节假日'),('劳动节','2024-05-04','法定节假日'),('劳动节','2024-05-05','法定节假日'),('国庆节','2024-10-04','法定节假日'),('国庆节','2024-10-05','法定节假日')
2024年节假日 sql脚本
01-04
要编写2024年的节假日SQL脚本，需要考虑中国的法定节假日和周末。下面是一个可以参考的示例脚本： ``` -- 创建节假日表 CREATE TABLE holidays ( id INT AUTO_INCREMENT PRIMARY KEY, date DATE NOT NULL, description VARCHAR(255) NOT NULL ); -- 插入法定节假日 INSERT INTO holidays (date, description) VALUES ('2024-01-01', '元旦'), ('2024-02-04', '春节'), ('2024-02-05', '春节'), ('2024-02-06', '春节'), ('2024-02-07', '春节'), ('2024-02-08', '春节'), ('2024-04-04', '清明节'), ('2024-05-01', '劳动节'), ('2024-05-02', '劳动节'), ('2024-05-03', '劳动节'), ('2024-06-07', '端午节'), ('2024-09-22', '中秋节'), ('2024-10-01', '国庆节'), ('2024-10-02', '国庆节'), ('2024-10-03', '国庆节'), ('2024-10-04', '国庆节'), ('2024-10-05', '国庆节'), ('2024-10-06', '国庆节'), ('2024-10-07', '国庆节'); -- 插入周末 INSERT INTO holidays (date, description) SELECT DATE_ADD('2024-01-01', INTERVAL (a.n + b.n*7) DAY) as date, '周末' as description FROM (SELECT 0 as n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6) a, (SELECT 0 as n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6) b WHERE DATE_ADD('2024-01-01', INTERVAL (a.n + b.n*7) DAY) BETWEEN '2024-01-01' AND '2024-12-31'; -- 输出节假日数据 SELECT * FROM holidays; ``` 上述脚本首先创建了一个名为"holidays"的表，用于存储节假日数据。然后通过INSERT语句插入了2024年的法定节假日和周末数据。最后通过SELECT语句输出了节假日数据。 注意：上述脚本仅作为示例，实际使用时可能需要根据具体需求进行修改。此外，中国的法定节假日可能会根据政府公告进行调整，因此脚本中的节假日日期和描述需要根据最新的官方公告进行更新。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值