How to convert varchar to date in PostgreSQL?

Question

Hi,

I have varchar data type column and date data type column . I have to update varchar column data into date column in PostgreSQL.

Is it possible?

Thanks.

chandu

Answer 1

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

Answer 2

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

Assuming you are saving "07 04 2010"

if not Reffer following link

:- http://www.postgresql.org/docs/8.1/interactive/functions-formatting.html