SELECT TO_CHAR(TO_TIMESTAMP('07-DEC-12 01.53.08.549000 PM', 'dd-mon-yy HH.MI.SSxff PM', 'NLS_DATE_LANGUAGE = American'), 'yyyy-mm-dd HH24:MI:SS') FROM DUAL;