ORACLE 获取给定日期的当前月所有日期和所有日期

幼稚怪

于 2024-01-04 16:01:56 发布

阅读量1.2k

点赞数 6

分类专栏：数据库文章标签： oracle 数据库 java

本文链接：https://blog.youkuaiyun.com/qq_35011890/article/details/135386436

版权

数据库专栏收录该内容

5 篇文章

订阅专栏

获取当前月所有日期

    SELECT TRUNC(TO_DATE('2023-01-01','YYYY-MM-dd'), 'MM') + LEVEL - 1 AS date_column
    FROM DUAL
    CONNECT BY LEVEL <= EXTRACT(DAY FROM LAST_DAY(TO_DATE('2023-01-01','YYYY-MM-dd')))

使用union all

    SELECT TRUNC(TO_DATE('2023-01-01','YYYY-MM-dd'), 'MM') + LEVEL - 1 AS date_column
    FROM DUAL
    CONNECT BY LEVEL <= EXTRACT(DAY FROM LAST_DAY(TO_DATE('2023-01-01','YYYY-MM-dd')))
    UNION ALL
    SELECT TRUNC(ADD_MONTHS(TO_DATE('2023-01-01','YYYY-MM-dd'), -1), 'MM') + LEVEL - 1 AS date_column
    FROM DUAL
    CONNECT BY LEVEL <= EXTRACT(DAY FROM LAST_DAY(ADD_MONTHS(TO_DATE('2023-01-01','YYYY-MM-dd'), -1)));