Re: date format

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 29 Oct 2001 15:16:51 GMT
Message-ID: <DpeD7.12506$ib.5403807_at_news1.sttln1.wa.home.com>


Try:
 select * from table where date> =to_date('29.10.2001','DD.MM.YYYY') and date<=to_date('30.10.2001','DD.MM.YYYY') ; Otherwise make a function based index. Remember there is a time component to dates.
Jim

"andrija" <ar35644_at_fer.hr> wrote in message news:9rj6tc$fitc$1_at_as201.hinet.hr...
> I have date column in a table and defined index on that column. When I
 query
> that table, I use 'where date between xxx and yyy'. Problem is that date
> column contains time also, which is not important to me.
> So if I use query like this:
>
> select * from table where to_char(date,'DD.MM.YYYY') ='29.10.2001'
>
> Does this query uses index? Should I create function based index? Is there
> any other easyer way? Can I force oracle to just ignore date in the column
> (because I've seen sometimes that time is not displayed in TOAD)?
>
>
Received on Mon Oct 29 2001 - 16:16:51 CET

Original text of this message