sql 输出连续日期、月份、年份

来源：互联网发布：500价位耳机知乎编辑：程序博客网时间：2024/05/21 09:03

        --天排序

select TO_CHAR(                              to_date('2017/05/01', ' YYYY/MM/dd ')                              + rownum - 1,                              'YYYY/MM/DD')  as dateString   from user_objects where 0 <=             (               to_date('2017/05/31', ' YYYY/MM/dd') -               (to_date('2017/05/01', ' YYYY/MM/dd ') + rownum - 1))          --月排序select TO_CHAR(add_months(                                                    to_date('2017/05', ' YYYY/MM '),                          rownum - 1                                                    ),               'YYYY/MM')  from user_objects where 0 <= (to_date('2018/05', ' YYYY/MM') -       add_months(to_date('2017/05', ' YYYY/MM '), rownum - 1));--年排序select rownum，TO_CHAR(add_months(to_date('2017', 'YYYY '),                                 (rownum - 1) * 12),                      'YYYY')  from user_objects where 0 <= (to_date('2023', ' YYYY') -       add_months(to_date('2017', ' YYYY'), (rownum - 1) * 12));

阅读全文

0 0