How to Convert VarChar to Date in PgSQL

From: "Venkat Rao Tammineni" <vtammineni(at)roulacglobal(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: How to Convert VarChar to Date in PgSQL
Date: 2009-03-10 12:07:38
Message-ID: 005901c9a178$d00c3c20$7024b460$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Dear All,

I have one table which has lot of data.In the same table I have one
varchar filed. I want to convert into Date data type? Is It possible to
convert varchar to date datatype with out loosing data.Please guide me.I am
waiting for your great response.

?Thanx & Regards

Venkat Rao Tammineni

GIS Developer

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raymond O'Donnell 2009-03-10 12:09:20 Re: [GENERAL] How to Convert VarChar to Date in PgSQL
Previous Message Péter Kovács 2009-03-10 10:39:32 Re: Version info in catalog

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-03-10 12:09:20 Re: [GENERAL] How to Convert VarChar to Date in PgSQL
Previous Message devi 2009-03-10 11:43:33 Re: PostgreSQL connect error