select to_char(sysdate,'DDMMYYYY') from dual