查询本周一到周五的数据
查询sql
SELECT
CASE
WHEN TO_CHAR(T.BEGINDATE, 'D') = 2 THEN '周一'
WHEN TO_CHAR(T.BEGINDATE, 'D') = 3 THEN '周二'
WHEN TO_CHAR(T.BEGINDATE, 'D') = 4 THEN '周三'
WHEN TO_CHAR(T.BEGINDATE, 'D') = 5 THEN '周四'
WHEN TO_CHAR(T.BEGINDATE, 'D') = 6 THEN '周五'
END AS DAY_NAME,
T.COLUMN1,
T.COLUMN2
FROM
BUSS_PLAN_CESHI T
WHERE
1 = 1
AND TO_CHAR(T.BEGINDATE, 'D') IN (2, 3, 4, 5, 6)
AND T.BEGINDATE >= TRUNC(SYSDATE, 'IW')
AND T.BEGINDATE < TRUNC(SYSDATE, 'IW') + 7
ORDER BY
TO_CHAR(T.BEGINDATE, 'D') ;
查询结果
