with t as
( select '141101' a, '090001' b from dual union all
select '141202', '110501' from dual
) select
substr(a,1,2)||'-'||substr(a,3,2)||'-'||substr(a,5,2)
,substr(b,1,2)||':'||substr(a,3,2)||':'||substr(a,5,2)
, to_char(to_date(a),'YY-MM-DD')
from t
by 에즈레인보우
[2014.12.22 17:05:32]
감사합니다^^잘 적용했습니다!!
by 이런잭쓴
[2014.12.22 17:00:50]
WITH TEST AS
(SELECT '141101' D, '090001' T FROM dual
UNION ALL
SELECT '141202' D, '110501' T FROM dual )
SELECT TO_DATE(D,'YYMMDD'), TO_CHAR(TO_DATE(T, 'hh24miss'),'hh:mm:ss') FROM TEST;
by 에즈레인보우
[2014.12.22 17:05:59]
도움이 되었습니다! 감사합니다!
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.