现在时间为8-20点的  查询昨天00点到今晚23.59.59的数据

现在时间为20-明天早上8点 查询中午12点到明天中午12点的数据

麻烦大佬帮我看下我的sql修改一下

SELECT MATERIALID 包装编码,

MACHINENAME 上料设备,

MACHINECODE 上料设备编码,

LINENAME 车间线体,

FGCODEVERSION 原料id,

STARTNUM 原料数量,

LASTNUM 剩余数量,

EVENTTIME 操作时间

FROM MATERIAL_ONLINE

WHERE WORKSHOPNAME='BL塑胶制造课'

AND MACHINECODE LIKE '%H%'

AND (TO_CHAR(EVENTTIME,'YYYY-MM-DD HH24:MI:SS') >=(CASE WHEN SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) < '08'

THEN TO_CHAR(SYSDATE - 1,'YYYY-MM-DD') || ' 12:00:00'

WHEN SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) >= '08' AND SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) < '20' THEN TO_CHAR(SYSDATE,'YYYY-MM-DD') || ' 23:59:59'

WHEN SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) >= '20' THEN TO_CHAR(SYSDATE,'YYYY-MM-DD') || ' 12:00:00'END)

AND TO_CHAR(EVENTTIME,'YYYY-MM-DD HH24:MI:SS') <(CASE WHEN SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) < '08'

THEN TO_CHAR(SYSDATE,'YYYY-MM-DD') || ' 12:00:00' WHEN SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) >= '08'

AND SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) < '20'

THEN TO_CHAR(SYSDATE,'YYYY-MM-DD') || ' 12:00:00'

WHEN SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS'),12,2) >= '20'

THEN TO_CHAR(SYSDATE + 1,'YYYY-MM-DD') || ' 12:00:00' END))

GROUP BY MATERIALID,

MACHINENAME,

MACHINECODE,

LINENAME,

FGCODEVERSION,

STARTNUM,

LASTNUM,

EVENTTIME

ORDER BY EVENTTIME