日期转换 to_timestamp
select to_timestamp('2017-10-2410:48:45.656000','yyyy-mm-dd hh24:mi:ssxff') from dual;
select to_timestamp('2017-12-15 10:40:10.345', 'yyyy-MM-dd HH24:MI:ss.ff') as mydate from dual;
日期转换 to_timestamp
select to_timestamp('2017-10-2410:48:45.656000','yyyy-mm-dd hh24:mi:ssxff') from dual;
select to_timestamp('2017-12-15 10:40:10.345', 'yyyy-MM-dd HH24:MI:ss.ff') as mydate from dual;