create table HOLIDY_DAY_2023
(
day VARCHAR2(20),
type VARCHAR2(10),
week_day VARCHAR2(20),
remark VARCHAR2(50),
is_work VARCHAR2(2)
);
-- Add comments to the columns
comment on column HOLIDY_DAY_2023.day
is '日期';
comment on column HOLIDY_DAY_2023.type
is '4:工作日 2:法定节假日 5:节假日调休的上班日 1:周末';
comment on column HOLIDY_DAY_2023.week_day
is '周几';
comment on column HOLIDY_DAY_2023.remark
is '备注';
comment on column HOLIDY_DAY_2023.is_work
is '是否为工作日';
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-01', '2', '星期日', '元旦', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-02', '2', '星期一', '元旦', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-03', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-04', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-05', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-06', '4', '星期五', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-07', '1', '星期六', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-08', '1', '星期日', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-09', '4', '星期一', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-10', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-11', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-12', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-13', '4', '星期五', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-14', '1', '星期六', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-15', '1', '星期日', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-16', '4', '星期一', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-17', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-18', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-19', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-20', '4', '星期五', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-21', '2', '星期六', '春节', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-22', '2', '星期日', '春节', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-23', '2', '星期一', '春节', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-24', '2', '星期二', '春节', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-25', '2', '星期三', '春节', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-26', '2', '星期四', '春节', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-27', '2', '星期五', '春节', '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-28', '5', '星期六', '调休上班', '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-29', '5', '星期日', '调休上班', '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-30', '4', '星期一', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-01-31', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-01', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-02', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-03', '4', '星期五', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-04', '1', '星期六', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-05', '1', '星期日', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-06', '4', '星期一', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-07', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-08', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-09', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-10', '4', '星期五', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-11', '1', '星期六', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-12', '1', '星期日', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-13', '4', '星期一', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-14', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-15', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-16', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-17', '4', '星期五', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-18', '1', '星期六', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-19', '1', '星期日', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-20', '4', '星期一', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-21', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-22', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-23', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-24', '4', '星期五', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-25', '1', '星期六', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-26', '1', '星期日', null, '0');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-27', '4', '星期一', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-02-28', '4', '星期二', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-03-01', '4', '星期三', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-03-02', '4', '星期四', null, '1');
insert into HOLIDY_DAY_2023 (DAY, TYPE, WEEK_DAY, REMARK, IS_WORK)
values ('2023-03-03', '4', '星期五', null, '1'
2023年日历（标记工作日，节假日，调休，周末），计算两个日期相差的工作日天数
5星 · 超过95%的资源 需积分: 5 117 浏览量
2022-12-12
16:48:58
上传
评论 3
收藏 20KB ZIP 举报 
2023年日历(标记工作日，周末，节假日，调休).zip （2个子文件） 
2023年日历SQL(标记工作日，周末，节假日，调休).sql 43KB
2023年日历(标注工作日，周末，节假日，调休).xlsx 21KB资源评论
月下无月2023-01-282023年05月06日是调休上班
31768660462023-01-30多谢斧正，已更改重新上传
