hi,all:
I have a table with a column as date type, I try to use it as a where 
condition: but it was not work.

select date,TO_DATE('2015-06-01','yyyy-MM-dd') 
,date=TO_DATE('2015-06-01','yyyy-MM-dd')from FARM_PRODUCT_PRICE limit 100;



and ,I can do it like this : 
select * from FARM_PRODUCT_PRICE where TO_CHAR(date, 'yyyy-MM-dd') = 
'2016-09-29' ;
but , it will not use index if I create index like this :
CREATE INDEX idx_fpp ON FARM_PRODUCT_PRICE (TO_CHAR(date, 'yyyy-MM-dd'));




thanks for any help.

2016-12-02


lk_phoenix 

Reply via email to