SELECT BBB.GPDAY ,BBB.NPDAY ,BBB.GP ,BBB.NP
FROM
(SELECT SUM(ROUND(floor((TIMESTAMP(E.ETDATDDTM||'00')-TIMESTAMP(E.ETAATADTM||'00'))/1000000) + ((TIMESTAMP(E.ETDATDDTM||'00')-TIMESTAMP(E.ETAATADTM||'00'))-floor((TIMESTAMP(E.ETDATDDTM||'00')-TIMESTAMP(E.ETAATADTM||'00'))/1000000)*1000000)/240000,2)) AS GPDAY
,SUM(ROUND(floor((TIMESTAMP(E.ETCATCDTM||'00')-TIMESTAMP(E.COMATCDTM||'00'))/1000000) + ((TIMESTAMP(E.ETCATCDTM||'00')-TIMESTAMP(E.COMATCDTM||'00'))-floor((TIMESTAMP(E.ETCATCDTM||'00')-TIMESTAMP(E.COMATCDTM||'00'))/1000000)*1000000)/240000,2)) AS NPDAY
,SUM((M.QTYFII+M.QTYBTT)/ROUND(floor((TIMESTAMP(E.ETDATDDTM||'00')-TIMESTAMP(E.ETAATADTM||'00'))/1000000) + ((TIMESTAMP(E.ETDATDDTM||'00')-TIMESTAMP(E.ETAATADTM||'00'))-floor((TIMESTAMP(E.ETDATDDTM||'00')-TIMESTAMP(E.ETAATADTM||'00'))/1000000)*1000000)/240000,2)) AS GP
,SUM((M.QTYFII+M.QTYBTT)/ROUND(floor((TIMESTAMP(E.ETCATCDTM||'00')-TIMESTAMP(E.COMATCDTM||'00'))/1000000) + ((TIMESTAMP(E.ETCATCDTM||'00')-TIMESTAMP(E.COMATCDTM||'00'))-floor((TIMESTAMP(E.ETCATCDTM||'00')-TIMESTAMP(E.COMATCDTM||'00'))/1000000)*1000000)/240000,2)) AS NP
FROM PLIBBS.OPRAVRSM M LEFT JOIN PLIBBS.OPRAVRTE E ON (M.VSLCOD = E.VSLCOD AND M.VOYCOD = E.VOYCOD AND M.MSTSEQ = E.MSTSEQ)
GROUP BY M.VSLCOD,M.VOYCOD,M.POTCOD,M.POTDSC,M.DPTDAT) BBB
이 쿼리를 돌리면 Syntax of date, time, or timestamp value not valid. 이런 메세지가 뜨면서 오류가 납니다.
TIMESTAMP의 잘못된 사용이라고 하는데,, 어떻게 수정하면 될까요? 고수님들의 답변 부탁드립니다. 감사합니다. |