데이터베이스 질문과 답변
datetime
00:01:41,000
00:02:39,000
00:05:45,000
00:06:41,000
00:07:01,000
00:08:21,000
00:11:41,000
이런 열이 있을때 각 시간의 차이를 뽑는 방법이 뭐가 있을까요?
by 우리집아찌
[2017.12.18 15:33:32]
원하시는 결과 포맷은요?
첫번째열이랑 마지막열 DATA 값은요?
WITH T (datetime) AS (
SELECT TO_TIMESTAMP( '00:01:41,000' , 'HH24:MI:SS,FF') FROM DUAL UNION ALL
SELECT TO_TIMESTAMP( '00:02:39,000' , 'HH24:MI:SS,FF') FROM DUAL UNION ALL
SELECT TO_TIMESTAMP( '00:05:45,000' , 'HH24:MI:SS,FF') FROM DUAL UNION ALL
SELECT TO_TIMESTAMP( '00:06:41,000' , 'HH24:MI:SS,FF') FROM DUAL UNION ALL
SELECT TO_TIMESTAMP( '00:07:01,000' , 'HH24:MI:SS,FF') FROM DUAL UNION ALL
SELECT TO_TIMESTAMP( '00:08:21,000' , 'HH24:MI:SS,FF') FROM DUAL UNION ALL
SELECT TO_TIMESTAMP( '00:11:41,000' , 'HH24:MI:SS,FF') FROM DUAL
)
SELECT DATETIME
, LAG(DATETIME) OVER(ORDER BY ROWNUM) AS BF_DATETIME
, DATETIME - LAG(DATETIME) OVER(ORDER BY ROWNUM) AS BF_DATETIME
FROM T
) 버튼을 클릭하여 작성 하시면 됩니다.