I have a table with a column as date type, I try to use it as a where
condition: but it was not work.
,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') =
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.