postgres date format mm/dd/yyyy code example

Example: postgresql format date dd/mm/yyyy

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