Stupid Monday Problem

Поиск
Список
Период
Сортировка
От Kenn Thompson
Тема Stupid Monday Problem
Дата
Msg-id s8fae784.037@10.0.0.4
обсуждение исходный текст
Ответы Re: Stupid Monday Problem  (<kaiq@realtyideas.com>)
Re: Stupid Monday Problem  (Andrew Perrin - Demography <aperrin@demog.berkeley.edu>)
Список pgsql-sql
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'tseem 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
retypethis query using an explicit cast 
 






В списке pgsql-sql по дате отправления:

Предыдущее
От: "J.Post"
Дата:
Сообщение: Connecting website with SQL-database.....
Следующее
От: Patrik Kudo
Дата:
Сообщение: Re: Stupid Monday Problem