Oracle数据库⽣成2022年节假⽇表SQL -- day_typ 0:⼯作⽇ 1:休息⽇ 2:节假⽇
insert into wkday
(wk_day, day_typ)
select wk_day,
case
when wk_day in ('20220101',
'20220102',
'20220103',
'20220131',
'20220201',
'20220202',
'20220203',
歇后语大全及答案搞笑'20220204',
'20220205',
'20220206',
'20220403',
干部作风整顿心得体会'20220404',
'20220405',
好听的女孩英文名字'20220430',
'20220501',
'20220502',
'20220503',
'20220504',
'20220603',
'20220604',
'20220605',
'20220910',
'20220911',
'20220912',
'20221001',
'20221002',
'20221003',
'20221004',
'20221005',
'20221006',
'20221007') then
'2'
when wk_day in ('20220129',
'20220130',
'20220402',
'20220424',
'20220507',
'20221008',
'20221009') then
汽车省油'0'
else
day_typ犯罪电影
end day_typ
from (select wk_day,
case
when trim(to_char(to_date(wk_day, 'YYYYMMDD'), 'day')) in
('星期六', '星期⽇') then
'1'
else
'0'
带有风的诗句end day_typ
from (select to_char(to_date('20220101', 'yyyyMMdd') + rownum - 1, 'yyyymmdd') as wk_day
from dual
connect by rownum <=
trunc(to_date('20221231', 'yyyyMMdd') -
to_date('20220101', 'yyyyMMdd')) + 1))
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。
发表评论