select to_char(date,'yyyy-mm-dd hh:mi:ss') from dual;
select to_date('2017-12-12 12:12:12' ,'yyyy-mm-dd hh24:mi:ss') from dual;
select to_char(date,'yyyy-mm-dd hh:mi:ss') from dual;
select to_date('2017-12-12 12:12:12' ,'yyyy-mm-dd hh24:mi:ss') from dual;