예
SELECT TO_DATE('20160901151212','YYYYMMDDHH24MISS') AS ONE
,TO_DATE('20160901091212','YYYYMMDDHHMISS') AS TWO
,TO_DATE('2016090115','YYYYMMDDHH24') AS THREE
,TO_DATE('2016','YYYY') AS FOUR
FROM DUAL
결과
ONE 2016-09-01 오후3:12:12
TWO 2016-09-01 오전9:12:12
THREE 2016-09-01 오후3:00:00
FOUR 2016-10-01 오전12:00:00