CODE EXAMPLE FOR SQL

sql format timestamp dd/mm/yyyy

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