Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id AC6FD634C2C; Tue, 10 Mar 2009 09:03:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 23211-03-4; Tue, 10 Mar 2009 09:03:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from IPDDFZ2047ATL2.f3technologies.com (unknown [216.247.254.67]) by mail.postgresql.org (Postfix) with ESMTP id 5B225634B18; Tue, 10 Mar 2009 09:03:42 -0300 (ADT) Received: from rgprtw74 ([203.196.150.245] RDNS failed) by IPDDFZ2047ATL2.f3technologies.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 10 Mar 2009 08:04:34 -0400 From: "Venkat Rao Tammineni" To: , Subject: How to Convert VarChar to Date in PgSQL Date: Tue, 10 Mar 2009 17:37:38 +0530 Message-ID: <005901c9a178$d00c3c20$7024b460$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005A_01C9A1A6.E9C47820" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcmheM18/g2X+dg1Rw+nRrSxbRC8hw== Content-Language: en-us X-OriginalArrivalTime: 10 Mar 2009 12:04:34.0781 (UTC) FILETIME=[60BB60D0:01C9A178] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.101 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200903/126 X-Sequence-Number: 31626 This is a multipart message in MIME format. ------=_NextPart_000_005A_01C9A1A6.E9C47820 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_005A_01C9A1A6.E9C47820 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_005A_01C9A1A6.E9C47820--