Skip site navigation (1) Skip section navigation (2)

Re: Stupid Monday Problem

From: Patrik Kudo <kudo(at)partitur(dot)se>
To: Kenn Thompson <KThompson(at)adestagroup(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Stupid Monday Problem
Date: 2000-04-17 15:49:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

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.)

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

In response to

pgsql-sql by date

Next:From: kaiqDate: 2000-04-17 16:00:34
Subject: Re: Stupid Monday Problem
Previous:From: Margarita BarvinokDate: 2000-04-17 15:48:57
Subject: Re: Connecting website with SQL-database.....

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group