统计每日昨晚20点到今天20点 的数据

select DATA_TIME,sum(WGT)*0.955 AS WGT,DEVICE_NUM
from (SELECT LIQ_TIME,DEVICE_NUM,
(case when substr(LIQ_TIME,12,2) >= 20 and substr(LIQ_TIME,12,2) <= 23 then substr(to_date(substr(LIQ_TIME,1,10)) +1,1,10) else substr(LIQ_TIME,1,10) END) DATA_TIME ,
WGT 
FROM TZGT.L2_LT_BF_IRON_WGT_GA 
WHERE  LIQ_TIME >= '2024-03-14' AND LIQ_TIME <='2024-03-21' 
)group by DATA_TIME,DEVICE_NUM ORDER BY DATA_TIME```