转换
select cast(to_date('2016/8/19','yyyy-mm-dd,hh24:mi:ss') as timestamp) date_to_timestamp from dual;
select TO_CHAR(to_timestamp('2016/8/19','yyyy-mm-dd hh24:mi:ss'),'YYYY-MM-DD HH24:MI:SS') from dual
select cast(to_date('2016/8/19','yyyy-mm-dd,hh24:mi:ss') as timestamp) date_to_timestamp from dual;
select TO_CHAR(to_timestamp('2016/8/19','yyyy-mm-dd hh24:mi:ss'),'YYYY-MM-DD HH24:MI:SS') from dual
