现在时间为8-20点的 查询昨天00点到今晚23.59.59的数据现在时间为20-明天早上8点 查询中午12点到明天中午12点的数据麻烦大佬帮我看下我的sql修改一下SELECT MATERIALID 包装编码,MACHINENAME 上料设备,MACHINECODE 上料设备编码,LINENAME 车间线体,FGCODEVERSION 原料id,STARTNUM 原料数量,LASTNUM 剩余数量,EVENTTIME 操作时间FROM MATERIAL_ONLINEWHERE 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,EVENTTIMEORDER BY EVENTTIME