phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ciureanu Constantin <ciureanu.constan...@gmail.com>
Subject Re: how to filter date type column ?
Date Fri, 02 Dec 2016 08:11:50 GMT
Try using WHERE clause...

... FROM FARM_PRODUCT_PRICE
WHERE date=TO_DATE('2015-06-01','yyyy-MM-dd')
LIMIT 100;

2016-12-02 6:43 GMT+01:00 lk_phoenix <lk_phoenix@163.com>:

> 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
>

Mime
View raw message