SELECT TO_CHAR(TO_TIMESTAMP(''20-DEC-17 02.30.30.000000000 PM','DD-MON-YY HH.MM.SS.FF PM'),'YYYY-MM-DD HH24 MI SS') FROM DUAL;
