Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BE260634ED9 for ; Tue, 10 Mar 2009 09:14:16 -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 27498-01-9 for ; Tue, 10 Mar 2009 09:14:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by mail.postgresql.org (Postfix) with ESMTP id 03741634BDF for ; Tue, 10 Mar 2009 09:13:47 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis) id 0ML31I-1Lh0q81swu-00053N; Tue, 10 Mar 2009 13:13:45 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1Lh0q7-00026Y-00 for pgsql-general@postgresql.org; Tue, 10 Mar 2009 13:13:43 +0100 Date: Tue, 10 Mar 2009 13:13:43 +0100 From: "A. Kretschmer" To: pgsql-general@postgresql.org Subject: Re: How to Convert VarChar to Date in PgSQL Message-ID: <20090310121343.GC13749@a-kretschmer.de> References: <005901c9a178$d00c3c20$7024b460$@com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <005901c9a178$d00c3c20$7024b460$@com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/sOCh9dsx1aokkxi3MBWuKIyfQr0DkLz/Ozan 2duteR61Q/rBkNqaiaWfeA5JRat5F/3I8QkBNzdL3IgDHqACX0 Wenm5TopGVieN2riqWrLRXZ+6jgRzL1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/360 X-Sequence-Number: 144946 In response to Venkat Rao Tammineni : > 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. Sure, if you have valid varchar-data. to_date('2009-03-11'::text, 'yyyy-mm-dd'); Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net