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 3AB473A47A3 for ; Thu, 18 Nov 2004 21:30:12 +0000 (GMT) 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 47103-02 for ; Thu, 18 Nov 2004 21:30:08 +0000 (GMT) Received: from mx-mtaout01.mts.net (wnpgmb02-group-smtpout.mts.net [142.161.130.102]) by svr1.postgresql.org (Postfix) with ESMTP id E72393A46AF for ; Thu, 18 Nov 2004 21:30:07 +0000 (GMT) Received: from [192.168.0.9] ([207.161.203.27]) by mx-mtaout01.mts.net with ESMTP id <20041118213007.KVVE1382.mx-mtaout01.mts.net@[192.168.0.9]> for ; Thu, 18 Nov 2004 15:30:07 -0600 Message-ID: <419D156C.5030302@candoltd.com> Date: Thu, 18 Nov 2004 15:34:36 -0600 From: Nick Peters User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Comparing Dates References: <419D0DC6.5080504@candoltd.com> <1d581afe04111813105e42b319@mail.gmail.com> In-Reply-To: <1d581afe04111813105e42b319@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/183 X-Sequence-Number: 19502 Thanks, it turns out that the code that was executing the sql was flawed. Thanks to all that replied! -Nick Ian Barwick wrote: >On Thu, 18 Nov 2004 15:01:58 -0600, Nick Peters > wrote: > > >>Hey, >> >>I am trying to compare dates in a sql statement. this is what i have tried: >> >>SELECT * FROM transactions WHERE shippingdate>2004-06-08 AND >>transtype='Sale'; >> >> > >SELECT * FROM transactions WHERE shippingdate> '2004-06-08' AND >transtype='Sale'; > >Ian Barwick > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > > >