Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA37740 for ; Mon, 17 Apr 2000 11:49:29 -0400 (EDT) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id RAA27138; Mon, 17 Apr 2000 17:49:25 +0200 (CEST) (envelope-from kudo@partitur.se) Message-ID: <38FB3284.52D36AC3@partitur.se> Date: Mon, 17 Apr 2000 17:49:24 +0200 From: Patrik Kudo X-Mailer: Mozilla 4.72 [en] (X11; I; FreeBSD 4.0-STABLE i386) X-Accept-Language: en MIME-Version: 1.0 To: Kenn Thompson CC: pgsql-sql@postgresql.org Subject: Re: Stupid Monday Problem References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/166 Hi. Dates should be quoted like '04/16/00' What you're trying to do is to calculate an integer of value 04/16/00 (which, if the parser would let it through, would even generate a division by zero error.) Regards, Patrik Kudo 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