mutable user:

I just started working on Postgres database and created few tables .For convenience initially, I used character varying(50) but now I want to change that to Date (dd/mm/yyyy) format.

I tried using this command

ALTER TABLE ip_role ALTER COLUMN event_dt TYPE date USING(event_dt::date);

also this-

ALTER TABLE ip_role ALTER COLUMN event_dt TYPE DATE using to_date(event_dt, 'DD/MM/YYYY');