| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> date column in where clause -> suppressing index?
When using date and time how do I search for specific dates most efficently?
Using where trunc(date,'DD') = to_date('26-07-2000','MM-DD-YYYY') the index
for the date column can't be used.
The time portion is important and can't be 00:00:00 and there is a lot of
searches for posts for a specific day.
TIA! /Jerra Received on Wed Jul 26 2000 - 00:00:00 CDT
 |
 |