mydate >'TODAY' not working on 6.5.1 with dbi - Mailing list pgsql-general

From
Subject mydate >'TODAY' not working on 6.5.1 with dbi
Date
Msg-id Pine.LNX.4.10.10003081030520.32133-100000@picasso.realtyideas.com
Whole thread Raw
In response to User authentication problem  (Guillermo Iglesias <guillermo@castelo.org>)
List pgsql-general
I used
 select mls,city,price,numbed,fb,ohsdate,ohystime,ohetime,address,dir,rem,
       apid,brokerid from mls where ohflag>0 and ohdate >= 'TODAY'

it works thro psql, but when I use it through dbi, it does not work.
note that the query without >='TODAY' works fine:
 select mls,city,price,numbed,fb,ohsdate,ohystime,ohetime,address,dir,rem,
       apid,brokerid from mls where ohflag>0

anybody ideas? thanks in advance!




pgsql-general by date:

Previous
From: JB
Date:
Subject: Re: [GENERAL] 50 MB Table
Next
From:
Date:
Subject: Cancel => mydate >'TODAY' not working on 6.5.1 with dbi (fwd)