I need to change the date format for an existing column in the table

select to\_date(dob, 'dd/mm/yyyy') as myDate;

This is to select the date while displaying. I need to change the existing column like update it completely