Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why this query is sooo slow?!
I tried, no impact at all. Thanks anyway.
> Which it can't use as you have written the query. try using the to_date
> function eg
>
> where
> n.apptimestamp >= to_date('05/02/2004 05:00:00','MM/DD/YYYY HH24:MI:SS')
> and n.apptimestamp < to_date('05/02/2004 06:00:00','MM/DD/YYYY
> HH24:MI:SS')
Received on Thu May 20 2004 - 15:37:28 CDT