下面代码是查询在 2021 年 4 月份,每天 9 点到 12 点的数据总数
SELECT
COUNT( ID )
FROM
TABLE_NAME
WHERE
DEPT_CODE = '1'
AND
FINISH_TIME BETWEEN '2021-04-01 00:00:00' AND '2021-04-30 23:59:59'
AND
to_date( SUBSTR( FINISH_TIME, - 9 ), 'hh24:mi:ss' )
BETWEEN to_date( '09:00:00', 'hh24:mi:ss' ) AND to_date( '12:00:00', 'hh24:mi:ss' );