select * from KQ_HolidaySet --节假日
select * from kq_group --考勤组
--changeType --1-公众假日 2-调配工作日 3-调配休息日
--relatedDay --0-星期一 1-星期二 2-星期三 3-星期四 4-星期五 5-星期六 6-星期日
select'' as 考勤组名称_必填,
holidayDate as 日期_必填,
case when changeType =1then'公众假日' when changeType =2then'调配工作日' when changeType =3then'调配休息日'else''end as 类型_必填,
holidayDesc as 节假日描述信息_说明,
case when relatedDay =0then'星期一' when relatedDay =1then'星期二' when relatedDay =2then'星期三' when relatedDay =3then'星期四' when relatedDay =4then'星期五' when relatedDay =5then'星期六' when relatedDay =6then'星期日'else''end as 调配工作日时对应的工作日_对应工作日
from KQ_HolidaySet where substring(holidayDate,0,5)='2023' -- 当前年份