Received: from hotmail.com (law-f267.hotmail.com [209.185.130.183]) by hub.org (8.9.3/8.9.3) with SMTP id IAA64589 for ; Wed, 27 Oct 1999 08:29:50 -0400 (EDT) (envelope-from oomoomi@hotmail.com) Received: (qmail 51359 invoked by uid 0); 27 Oct 1999 12:29:20 -0000 Message-ID: <19991027122920.51358.qmail@hotmail.com> Received: from 195.200.226.109 by www.hotmail.com with HTTP; Wed, 27 Oct 1999 05:29:18 PDT X-Originating-IP: [195.200.226.109] From: "omid omoomi" To: postgres@weblynk.com, pgsql-sql@postgreSQL.org Subject: Re: [SQL] Date comparisons Date: Wed, 27 Oct 1999 05:29:18 PDT Mime-Version: 1.0 Content-Type: text/plain; format=flowed hello ,try this : select * from a where a.cdate < '10-20-1999' ; regards, omid omoomi >From: Rich Ryan >To: "pgsql-sql@postgresql.org" >Subject: [SQL] Date comparisons >Date: Tue, 26 Oct 1999 23:46:04 -0700 > >I'm trying to do a > < on a date field. Not having any luck. My query looks >like >select * from a where a.cdate > Date('10-20-1999'); >I've tried every different date string format I can think of with no >dashes, >colons, different orderings of the month, date, and year, etc. no luck. Any >hints? >Thanks, >Rich > > > >************ > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com