Thread: Search problem

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

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

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