日期:2014-05-17 浏览次数:20679 次
select cast(to_timestamp('Jun 19 2013 5:51:53.000am', 'Mon dd yyyy hh:mi:ss.ffpm', 'NLS_DATE_LANGUAGE = American') as date) from dual;