Received: from cr15.cristorei.com.br (cr15.cristorei.com.br [200.230.89.96]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBJK3o614986 for ; Tue, 19 Dec 2000 15:03:51 -0500 (EST) (envelope-from mestredosmagos@marilia.com) Received: from marilia.com (escritorio.akacia.com.br [200.230.89.78]) by cr15.cristorei.com.br (8.9.3/8.8.7) with ESMTP id SAA22623; Tue, 19 Dec 2000 18:04:25 -0200 Message-ID: <3A3FC155.9A4709EB@marilia.com> Date: Tue, 19 Dec 2000 18:13:09 -0200 From: Tulio Oliveira Organization: Akacia Tecnologia X-Mailer: Mozilla 4.73 [pt_BR] (X11; U; Linux 2.2.14-19cl i686) X-Accept-Language: en MIME-Version: 1.0 To: Jeff MacDonald CC: pgsql-sql@postgresql.org Subject: Re: substring .. References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200012/228 X-Sequence-Number: 565 Jeff MacDonald wrote: > > hi folks.. > > i want to do this to a datetime field.. > > select foo from table where substr(datefoo,1,11) = '2000-12-14'; > > it returns no results yet.. > > select substr(datefoo,1,11) does return some values that say > 2000-12-14 > > any clues ? > > Jeff MacDonald, > > ----------------------------------------------------- > PostgreSQL Inc | Hub.Org Networking Services > jeff@pgsql.com | jeff@hub.org > www.pgsql.com | www.hub.org > 1-902-542-0713 | 1-902-542-3657 > ----------------------------------------------------- > Facsimile : 1 902 542 5386 > IRC Nick : bignose > PGP Public Key : http://bignose.hub.org/public.txt try remove the "-" from your WHERE clausule... This signal appears only in SELECT results... -- ====================================================== AKACIA TECNOLOGIA Desenvolvimento de sistemas para Internet www.akacia.com.br