oracle sql 带毫秒日期字符串转为Date格式

select cast(to_timestamp('2019-06-28 11:34:12.100', 'yyyy-MM-dd HH24:MI:ss.ff') as date) as mydate from dual;