in reply to Shorter Formating?
select to_char(sysdate,'YYYY-MM-DD HH:MI:SS') from dual; [download]
select getdate() [download]