How to convert column type from varchar to date in PostgreSQL?

sql postgresql type-conversion

ALTER TABLE <tablename> ALTER COLUMN <columnname> TYPE DATE using to_date(<columnname>, 'YYYY-MM-DD');

sql postgresql type-conversion

UPDATE tableName SET dateColumn=to_date(varcharColumn, 'DD MM YYYY')

Assuming you are saving "07 04 2010"

You can find further examples and explanation in the documentation:

sql postgresql type-conversion

to_date('05 Dec 2000', 'DD Mon YYYY')

CodeHunter