oracle 周六周末计算

Leviathan__

于 2024-10-14 11:12:22 发布

阅读量946

点赞数 3

CC 4.0 BY-SA版权

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/Leviathan__/article/details/142913357

SELECT
CHINA_WEEK AS WEEK ,TO_DATE(DATETIME, 'yyyy-MM-dd')
FROM
(
SELECT
    to_char(TO_DATE('2024-09-03', 'yyyy-MM-dd') - LEVEL, 'd') AS week,
    decode(to_char(TO_DATE('2024-09-03', 'yyyy-MM-dd') - LEVEL, 'd'), 1, '星期一', 2, '星期二', 3, '星期三', 4, '星期四', 5, '星期五', 6, '星期六', 7, '星期日') AS china_week,
    TO_CHAR((TO_DATE('2024-09-03', 'yyyy-MM-dd') - (ROWNUM - 1)), 'yyyy-MM-dd') AS datetime
FROM
    dual a
CONNECT BY
    LEVEL <= trunc(TO_DATE('2024-09-03', 'yyyy-MM-dd') - TO_DATE('2024-05-01', 'yyyy-MM-dd')+ 1)
ORDER BY
    datetime) d
WHERE
d.week IN (6, 7)