How to change format date

[raf]

Originally posted by 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')

ok, but if I've
to_date(sting_column,'DD/MM/YYYY') DATE_TODAY


with this output :

DATE_TODAY
2/22/0005

How Can I change it?