| From: | <kaiq(at)realtyideas(dot)com> |
|---|---|
| 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:00:34 |
| Message-ID: | Pine.LNX.4.10.10004171059260.27021-100000@picasso.realtyideas.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
try (add '' around date literal):
SELECT oid FROM file_header WHERE expire_date < '04/16/00'
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 | Andrew Perrin - Demography | 2000-04-17 16:20:31 | Re: Stupid Monday Problem |
| Previous Message | Patrik Kudo | 2000-04-17 15:49:24 | Re: Stupid Monday Problem |