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!