CODE EXAMPLE FOR SQL

postgresql format date dd/mm/yyyy

select to_char(date_col, 'DD/MM/YYYY') from table;