to_timestamp('2006-01-01 12:10:10.1','yyyy-mm-dd hh24:mi:ss.ff'), select to_date(substr('2013-10-31 16:42:21.061',1,10),'yyyy-mm-dd') from dual;