You could use Oracle SQL as:

select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual;
or
select to_char(sysdate, 'YYYYMMDD') from dual;
[download]

To let Oracle do the formatting.