oracle sql语句组装的日历
/*
日历(wyj)
*/
with aa as(select rownum as tian,to_char(to_date(‘198212’||to_char(rownum,‘00’),‘yyyymmdd’),‘dy’) as week from dual
connect by rownum<=to_number(to_char(last_day(to_date(‘198212’,‘yyyymm’)),‘dd’))),
bb as(
select ‘星期一’ as 星期一,‘星期二’ as 星期二,
原创
2021-06-09 16:00:12 ·
105 阅读 ·
0 评论