select to_char(to_timestamp('Jun 30 2010 12:00:00:000PM','mm-dd-yyyy hh12:MI:SS:ff3AM','NLS_DATE_LANGUAGE = American'),'YYYY-MM-DD') from dual
Oracle 英文日期转换为数字日期
最新推荐文章于 2023-12-26 14:42:10 发布
select to_char(to_timestamp('Jun 30 2010 12:00:00:000PM','mm-dd-yyyy hh12:MI:SS:ff3AM','NLS_DATE_LANGUAGE = American'),'YYYY-MM-DD') from dual