칼럼의 TYPE 은 VARCHAR2(4) 이고 데이터 형태는 HH24MI 입니다.
SELECT '1203' AS TO_HH24MI, '1201' AS FROM_HH24MI FROM DUAL UNION ALL
SELECT '2300' AS TO_HH24MI, '0430' AS FROM_HH24MI FROM DUAL UNION ALL
SELECT '1111' AS TO_HH24MI, '1111' AS FROM_HH24MI FROM DUAL UNION ALL
SELECT '1800' AS TO_HH24MI, '0900' AS FROM_HH24MI FROM DUAL UNION ALL
SELECT '1500' AS TO_HH24MI, '1000' AS FROM_HH24MI FROM DUAL UNION ALL
SELECT '1730' AS TO_HH24MI, '1533' AS FROM_HH24MI FROM DUAL
샘플입니다.
몇 시간 몇 분이 아닌 몇분의 차가 나는지 알고 싶습니다. |