From: | Andrew Perrin - Demography <aperrin(at)demog(dot)berkeley(dot)edu> |
---|---|
To: | Kenn Thompson <KThompson(at)adestagroup(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Stupid Monday Problem |
Date: | 2000-04-17 16:20:31 |
Message-ID: | Pine.SUN.4.10.10004170919260.6206-100000@davis.DEMOG.Berkeley.EDU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)demog(dot)berkeley(dot)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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Caley | 2000-04-17 16:22:15 | Re: [SQL] Connecting website with SQL-database..... |
Previous Message | kaiq | 2000-04-17 16:00:34 | Re: Stupid Monday Problem |