qq_41846456的博客

Oracle获取指定时间的所有日期 根据开始结束时间 获取指定范围内的年月 （年月日） SELECT distinct(TO_CHAR((TO_DATE('2019-01', 'yyyy-MM') + (ROWNUM - 1)),'yyyy-MM')) DT FROM DUAL CONNECT BY ROWNUM <= (TO_DATE('2019-12', 'yyyy-MM') - TO...

测试数据 with aa as ( SELECT 1 a,'2019-01-03' times FROM dual union SELECT 2 a,'2019-01-02' times FROM dual union SELECT 3 a,'2019-01-04' times FROM dual union SELECT 4 a,'2019-01-05' times FROM dual uni...