Oscar wrote:
> I am using apache/php and postgres and I tried a search with dates, but it
> doesn't accept it...
>
> select * from table where date_field < 10-10-2000;
>
> It yells that I cannot use < signs with ints and dates...
>
> Any suggestions ??
Use quotes for *anything* other than numbers. A date is not a number so
try:
select * from table where date_field < '10-10-2000' ;
However, depending on how dates are formatted it might be better written
as
select * from table where date_field < '2000-10-10' ;
--Jim