Received: from davis.DEMOG.Berkeley.EDU (davis.DEMOG.Berkeley.EDU [128.32.93.8]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA06366 for ; Mon, 17 Apr 2000 12:22:05 -0400 (EDT) (envelope-from aperrin@demog.berkeley.edu) Received: from localhost (aperrin@localhost) by davis.DEMOG.Berkeley.EDU (8.9.3/8.9.1) with ESMTP id JAA06271; Mon, 17 Apr 2000 09:20:31 -0700 (PDT) Date: Mon, 17 Apr 2000 09:20:31 -0700 (PDT) From: Andrew Perrin - Demography To: Kenn Thompson cc: pgsql-sql@postgresql.org Subject: Re: Stupid Monday Problem In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200004/168 You have to cast the date properly - postgres is interpreting this as 4 divided by 16 divided by 0. Try: SELECT oid FROM file_header WHERE expire_date < '04/16/00'::date; --------------------------------------------------------------------- Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support Department of Demography - University of California at Berkeley 2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA http://demog.berkeley.edu/~aperrin --------------------------SEIU1199 On Mon, 17 Apr 2000, Kenn Thompson wrote: > Ok- here's the problem ( too little coffee?)... > > This query runs under Access. I of course change a bit of the SQL ( removed the '#' and have played with quotes), but can't seem to get it to run. > > What the #%$^& am I doing wrong here? > > Kenn > > > SELECT oid FROM file_header WHERE expire_date < 04/16/00 > ADODB.Recordset.1 error '80004005' > > Error while executing the query; ERROR: Unable to identify an operator '<' for types 'date' and 'int4' You will have to retype this query using an explicit cast > > > >