CODE EXAMPLE FOR SQL

to_char oracle

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