X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8C26453B59 for ; Fri, 22 Apr 2005 06:13:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61955-02 for ; Fri, 22 Apr 2005 09:13:47 +0000 (GMT) Received: from nordine.ateur (main.librelogiciel.com [62.212.108.58]) by svr1.postgresql.org (Postfix) with ESMTP id C4ECB53B17 for ; Fri, 22 Apr 2005 06:13:46 -0300 (ADT) Received: from jerome by nordine.ateur with local (Exim 3.36 #1 (Debian)) id 1DOuEH-0003gH-00; Fri, 22 Apr 2005 11:13:41 +0200 Date: Fri, 22 Apr 2005 11:13:41 +0200 To: Ramakrishnan Muralidharan Cc: pgsql-sql@postgresql.org Subject: Re: string to date conversion Message-ID: <20050422091341.GE12176@mail.librelogiciel.com> References: <02767D4600E59A4487233B23AEF5C5992A407D@blrmail1.aus.pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <02767D4600E59A4487233B23AEF5C5992A407D@blrmail1.aus.pervasive.com> User-Agent: Mutt/1.5.9i From: Jerome Alet X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/321 X-Sequence-Number: 21214 On Fri, Apr 22, 2005 at 02:38:43PM +0530, Ramakrishnan Muralidharan wrote: > Hi, > > I have tried the same in PostgreSQL 8.0.1 and it is working fine. I have used following example for testing > > create table test1 > ( > date varchar(10) > ) > > insert into test1 values('2005/04/22') > > select date::timestamp from test1 Sorry, I should have said that I use 7.4.7... I know it's old but as already explained I can't do much about it for now... Thanks for your help bye Jerome Alet