查询本周一到周五的数据

查询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') ;

查询结果