Oracle里怎么将字符串转成想要的字符串格式

Question

比如"20161103083025" 转变成"2016/11/03 08：30：25"

Answer 1

 select to_date('20161103083025','yyyy/mm/dd hh24:mi:ss') as newdate from dual;