insert into T_STATISTICAL_TIME(DATETIME)
select to_date('20220101','yyyymmdd')+rownum-1
from all_objects
where rownum <= to_char(to_date('20221231','yyyymmdd'),'ddd');
insert into T_STATISTICAL_TIME(DATETIME)
select to_date('20230101','yyyymmdd')+rownum-1
from all_objects
where rownum <= to_char(to_date('20231231','yyyymmdd'),'ddd');
UPDATE T_STATISTICAL_TIME SET YEAR = to_char(DATETIME,'YYYY');
UPDATE T_STATISTICAL_TIME SET MONTH = to_char(DATETIME,'MM');
UPDATE T_STATISTICAL_TIME SET DAY = to_char(DATETIME,'dd');
ORCAL 生成指定年份日期并且获取日期的年月日
最新推荐文章于 2023-02-24 17:44:31 发布