oracle to_char to_date

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;