- 博客(1)
- 资源 (3)
- 收藏
- 关注
原创 mysql查询 工作时间段 与 非工作时间段数据,包含法定节假日
要求:查询工作时间与非工作时间(工作时间:周一周五8:30-17:30,其他时间为非工作时间)1. 查询工作时间SQL说明:过滤条件为周1到周5(非8:30-17:30)select date_format(create_time,'%Y-%m-%d %H:%i:%s') as create_time, date_format(create_time,'%w') as weekNumfrom sys_log_loginwhere date_format(create_time,'%w')
2021-10-12 11:14:04 5654
tb_work_day(2015-2021).sql
包括数据:2015-2021 每一天的数据,
举例 work_day_type:0工作日,1法定节假日, 2休息日加班, 3休息日
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211001', '2021-10-01', 5, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211002', '2021-10-02', 6, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211003', '2021-10-03', 0, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211004', '2021-10-04', 1, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211005', '2021-10-05', 2, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211006', '2021-10-06', 3, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211007', '2021-10-07', 4, '1');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211008', '2021-10-08', 5, '0');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211009', '2021-10-09', 6, '2');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211010', '2021-10-10', 0, '3');
INSERT INTO tb_work_day(id, work_day, week_num, work_day_type) VALUES ('20211011', '2021-10-11', 1, '0');
2021-10-14
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人