CvUMMBqr(提问者)字段的类型是Float
正常显示的那张数据类型是varchar2
SELECT H.EQP_ID,ROUND(TRIM(H.MTBA)/60, 2) MTBAH,TO_CHAR(TO_DATE(T.CREATE_TIME, \'RRRRMMDDHH24\'), \'RR-MM-DD-HH24\') TIME,SUBSTR( H.CREATE_TIME, 1, 10 ) CTD
FROM CUST_TEST_UPH_HIST H,
(SELECT EQP_ID,CREATE_TIME,MAX(TIME) TIME FROM (SELECT T.EQP_ID, TO_CHAR(T.CREATE_TIME,\'YYYYMMDDHH24\') CREATE_TIME, TO_CHAR(T.CREATE_TIME, \'YYYYMMDDHH24MISS\') TIME
FROM CUST_TEST_UPH_HIST T
WHERE T.MTBA <> \'NULL\'
AND T.MTBA IS NOT NULL
)
GROUP BY EQP_ID,CREATE_TIME) T
WHERE TO_CHAR(H.CREATE_TIME, \'YYYYMMDDHH24MISS\') = T.TIME
AND H.EQP_ID = T.EQP_ID
AND H.MTBA <> \'NULL\'
AND H.MTBA IS NOT NULL
AND H.EQP_ID = \'${EQP_ID}\'
AND SUBSTR( H.CREATE_TIME, 1, 10 ) = \'${CTD}\'
ORDER BY H.CREATE_TIME,H.EQP_ID