2020年节假日和周六日统计

工作日统计

定时任务,排除非工作日,找了几个接口都失效了,所以统计成了表,每年12月份去维护一下就好,这次是2020年的所有节假日和周六日统计。

INSERT INTO `holiday` VALUES ('1', '20200101');
INSERT INTO `holiday` VALUES ('2', '20200104');
INSERT INTO `holiday` VALUES ('3', '20200105');
INSERT INTO `holiday` VALUES ('4', '20200111');
INSERT INTO `holiday` VALUES ('5', '20200112');
INSERT INTO `holiday` VALUES ('6', '20200118');
INSERT INTO `holiday` VALUES ('7', '20200119');
INSERT INTO `holiday` VALUES ('8', '20200124');
INSERT INTO `holiday` VALUES ('9', '20200125');
INSERT INTO `holiday` VALUES ('10', '20200126');
INSERT INTO `holiday` VALUES ('11', '20200127');
INSERT INTO `holiday` VALUES ('12', '20200128');
INSERT INTO `holiday` VALUES ('13', '20200129');
INSERT INTO `holiday` VALUES ('14', '20200130');
INSERT INTO `holiday` VALUES ('15', '20200201');
INSERT INTO `holiday` VALUES ('16', '20200202');
INSERT INTO `holiday` VALUES ('17', '20200208');
INSERT INTO `holiday` VALUES ('18', '20200209');
INSERT INTO `holiday` VALUES ('19', '20200215');
INSERT INTO `holiday` VALUES ('20', '20200216');
INSERT INTO `holiday` VALUES ('21', '20200222');
INSERT INTO `holiday` VALUES ('22', '20200223');
INSERT INTO `holiday` VALUES ('23', '20200229');
INSERT INTO `holiday` VALUES ('24', '20200301');
INSERT INTO `holiday` VALUES ('25', '20200307');
INSERT INTO `holiday` VALUES ('26', '20200308');
INSERT INTO `holiday` VALUES ('27', '20200314');
INSERT INTO `holiday` VALUES ('28', '20200315');
INSERT INTO `holiday` VALUES ('29', '20200321');
INSERT INTO `holiday` VALUES ('30', '20200322');
INSERT INTO `holiday` VALUES ('31', '20200328');
INSERT INTO `holiday` VALUES ('32', '20200329');
INSERT INTO `holiday` VALUES ('33', '20200404');
INSERT INTO `holiday` VALUES ('34', '20200405');
INSERT INTO `holiday` VALUES ('35', '20200406');
INSERT INTO `holiday` VALUES ('36', '20200411');
INSERT INTO `holiday` VALUES ('37', '20200412');
INSERT INTO `holiday` VALUES ('38', '20200418');
INSERT INTO `holiday` VALUES ('39', '20200419');
INSERT INTO `holiday` VALUES ('40', '20200425');
INSERT INTO `holiday` VALUES ('41', '20200426');
INSERT INTO `holiday` VALUES ('42', '20200501');
INSERT INTO `holiday` VALUES ('43', '20200502');
INSERT INTO `holiday` VALUES ('44', '20200503');
INSERT INTO `holiday` VALUES ('45', '20200504');
INSERT INTO `holiday` VALUES ('46', '20200505');
INSERT INTO `holiday` VALUES ('47', '20200509');
INSERT INTO `holiday` VALUES ('48', '20200510');
INSERT INTO `holiday` VALUES ('49', '20200516');
INSERT INTO `holiday` VALUES ('50', '20200517');
INSERT INTO `holiday` VALUES ('51', '20200523');
INSERT INTO `holiday` VALUES ('52', '20200524');
INSERT INTO `holiday` VALUES ('53', '20200530');
INSERT INTO `holiday` VALUES ('54', '20200531');
INSERT INTO `holiday` VALUES ('55', '20200606');
INSERT INTO `holiday` VALUES ('56', '20200607');
INSERT INTO `holiday` VALUES ('57', '20200613');
INSERT INTO `holiday` VALUES ('58', '20200614');
INSERT INTO `holiday` VALUES ('59', '20200620');
INSERT INTO `holiday` VALUES ('60', '20200621');
INSERT INTO `holiday` VALUES ('61', '20200625');
INSERT INTO `holiday` VALUES ('62', '20200626');
INSERT INTO `holiday` VALUES ('63', '20200627');
INSERT INTO `holiday` VALUES ('64', '20200628');
INSERT INTO `holiday` VALUES ('65', '20200704');
INSERT INTO `holiday` VALUES ('66', '20200705');
INSERT INTO `holiday` VALUES ('67', '20200711');
INSERT INTO `holiday` VALUES ('68', '20200712');
INSERT INTO `holiday` VALUES ('69', '20200718');
INSERT INTO `holiday` VALUES ('70', '20200719');
INSERT INTO `holiday` VALUES ('71', '20200725');
INSERT INTO `holiday` VALUES ('72', '20200726');
INSERT INTO `holiday` VALUES ('73', '20200801');
INSERT INTO `holiday` VALUES ('74', '20200802');
INSERT INTO `holiday` VALUES ('75', '20200808');
INSERT INTO `holiday` VALUES ('76', '20200809');
INSERT INTO `holiday` VALUES ('77', '20200815');
INSERT INTO `holiday` VALUES ('78', '20200816');
INSERT INTO `holiday` VALUES ('79', '20200822');
INSERT INTO `holiday` VALUES ('80', '20200823');
INSERT INTO `holiday` VALUES ('81', '20200829');
INSERT INTO `holiday` VALUES ('82', '20200830');
INSERT INTO `holiday` VALUES ('83', '20200905');
INSERT INTO `holiday` VALUES ('84', '20200906');
INSERT INTO `holiday` VALUES ('85', '20200912');
INSERT INTO `holiday` VALUES ('86', '20200913');
INSERT INTO `holiday` VALUES ('87', '20200919');
INSERT INTO `holiday` VALUES ('88', '20200920');
INSERT INTO `holiday` VALUES ('89', '20200926');
INSERT INTO `holiday` VALUES ('90', '20200927');
INSERT INTO `holiday` VALUES ('91', '20201001');
INSERT INTO `holiday` VALUES ('92', '20201002');
INSERT INTO `holiday` VALUES ('93', '20201003');
INSERT INTO `holiday` VALUES ('94', '20201004');
INSERT INTO `holiday` VALUES ('95', '20201005');
INSERT INTO `holiday` VALUES ('96', '20201006');
INSERT INTO `holiday` VALUES ('97', '20201007');
INSERT INTO `holiday` VALUES ('98', '20201008');
INSERT INTO `holiday` VALUES ('99', '20201010');
INSERT INTO `holiday` VALUES ('100', '20201011');
INSERT INTO `holiday` VALUES ('101', '20201017');
INSERT INTO `holiday` VALUES ('102', '20201018');
INSERT INTO `holiday` VALUES ('103', '20201024');
INSERT INTO `holiday` VALUES ('104', '20201025');
INSERT INTO `holiday` VALUES ('105', '20201031');
INSERT INTO `holiday` VALUES ('106', '20201101');
INSERT INTO `holiday` VALUES ('107', '20201107');
INSERT INTO `holiday` VALUES ('108', '20201108');
INSERT INTO `holiday` VALUES ('109', '20201114');
INSERT INTO `holiday` VALUES ('110', '20201115');
INSERT INTO `holiday` VALUES ('111', '20201121');
INSERT INTO `holiday` VALUES ('112', '20201122');
INSERT INTO `holiday` VALUES ('113', '20201128');
INSERT INTO `holiday` VALUES ('114', '20201129');
INSERT INTO `holiday` VALUES ('115', '20201205');
INSERT INTO `holiday` VALUES ('116', '20201206');
INSERT INTO `holiday` VALUES ('117', '20201212');
INSERT INTO `holiday` VALUES ('118', '20201213');
INSERT INTO `holiday` VALUES ('119', '20201219');
INSERT INTO `holiday` VALUES ('120', '20201220');
INSERT INTO `holiday` VALUES ('121', '20201226');
INSERT INTO `holiday` VALUES ('122', '20201227');

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
要编写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语句输出了节假日数据。 注意:上述脚本仅作为示例,实际使用时可能需要根据具体需求进行修改。此外,中国的法定节假日可能会根据政府公告进行调整,因此脚本中的节假日期和描述需要根据最新的官方公告进行更新。

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值