select * from b where E.LADLE_ARR_TIME>='${FORMAT(STARTTIME,"yyyy-MM-dd 08:00:00")}' and rq <='${FORMAT(DATEDELTA(STARTTIME,1),"yyyy-MM-dd 08:00:00")}'
白少(提问者)SELECT E.HEAT_ID 炉次号,
to_char (E.STAR_CAST_TIM,\'MM-DD\') AS 生产时间,
E.TUNDISH_TEMP_AVG2 最高温度,
E.Tundish_Temp_Avg1 最低温度,
E.STL_COD 钢种代码
FROM SMES.SMES_B_CCMRES E where
E.LADLE_ARR_TIME >=\'${FORMAT(today(),\"yyyy-MM-dd 08:00:00\")}\' and E.LADLE_ARR_TIME <=\'${FORMAT(DATEDELTA(today(),1),\"yyyy-MM-dd 08:00:00\")}\' and
E.LADLE_ARR_TIME between
TO_DATE(\'${STARTTIME}\',\'YYYY-MM-DD yyyy-MM-dd 08:00:00\') AND
TO_DATE(\'${ENDTIME}\', \'YYYY-MM-DD yyyy-MM-dd 08:00:00\')
order by E.LADLE_ARR_TIME 我这样写报错了