oracle to

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;