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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Date comparison question

Re: Date comparison question

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Mon, 08 Jan 2001 21:28:55 +0100
Message-Id: <10735.126050@fatcity.com>


Lisa,

   Queries which 'do not return' are usually queries performing full scans of death. Since the cases which return happen to be, against common wisdom, those where the date column is converted to char, could it be possible that you have a function-based index (doing the to_char() conversion) on this column ?

Regards,

Stephane Faroult
Oriole Corporation

Lisa Yates wrote:

> Why doesn't this query ever return...
>
> where run_date = to_date('01-03-2001 16:34:59','mm-dd-yyyy hh24:mi:ss')
>
> but this query does....
>
> where to_char(run_date) = to_char(to_date('01-03-2001
> 16:34:59','mm-dd-yyyy hh24:mi:ss'))
>
> and so does this query....
>
> where to_char(run_date,'mm-dd-yyyy hh24:mi:ss') = '01-03-2001 16:34:59'
>
> ?
>
> TIA
>
> Lisa
>
>
> ********************************************
> * Lisa Yates cosnit_at_creighton.edu *
> * Creighton University *
> * Omaha, Nebraska *
> * (402) 280-2419 fax: (402) 280-2573 *
> * Define the Universe, give 2 examples. *
> ********************************************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Lisa Yates
Received on Mon Jan 08 2001 - 14:28:55 CST

Original text of this message

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