比如"20161103083025" 转变成"2016/11/03 08：30：25"
select to_date('20161103083025','yyyy/mm/dd hh24:mi:ss') as newdate from dual;
把字段类型改成datatime类型试试？
http://blog.csdn.net/foxbryant/article/details/6818670