Re: Search problem

Try:-

select * from table where date_field < '10-10-2000'::datetime; (or date if
your date_field is of type date)

Regards
Julie Hunt

Oscar wrote:

> Hi,
>
> 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 ??
>
> Thanks,
> Oscar