Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: to_date function

Re: to_date function

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 19 Dec 2001 14:09:19 GMT
Message-ID: <jc1U7.7678$Ah.446080@rwcrnsc52>


Look in the documentation under the Oracle Application developers Guide. Yes, you can create a function based index, which is a good idea. Jim
"Nicolas Bronke" <bronke_at_gmx.net> wrote in message news:9vpr0k$gvlrp$1_at_ID-121870.news.dfncis.de...
> > Yes, you can truncate the created_date, but that will force a full table
> > scan just to get the date component as of midnight.
>
> Is that true? I do not believe that. Where can I read about such.
>
> select * from tableA where trunc(created_date) = to_date('15/12/01',
> 'dd/mm/yy');
>
> regards
>
> Nicolas
>
>
Received on Wed Dec 19 2001 - 08:09:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US