date format yyyy-mm-ddthh mm ss postgres code example

Example: postgresql format date dd/mm/yyyy

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