随笔分类 - Oracle

Oracle 查询日期之间的所有月份

摘要：SELECT listagg(YYYYMM,',') within group (order by YYYYMM) DATE_STR from ( SELECT DISTINCT(TO_CHAR(T.ROWDATE, 'yyyy-mm')) YYYYMM FROM ( SELECT ROWNUM, TO_DATE('2018-01', 'yyyy-mm') + RO... 阅读全文

posted @ 2018-10-12 15:36 沛昕的博客阅读(3888) 评论(0) 推荐(0)