CODE EXAMPLE FOR SQL

to_char sql

SELECT TO_CHAR(sysdate, 'DD-MM-YYYY') from dual;