How to change format date

[padders]

NEVER use TO_DATE on a DATE (it is for converting strings to DATEs). To display a DATE in a required format use TO_CHAR with appropriate date mask, e.g.

TO_CHAR (date_column, 'DD/MM/YYYY')