Hello,

While executing the following query the execution time is more since the to_date funtion used in where condition.

select admission_date from iptran where to_date(admission_date) between to_date('26-10-2002','dd-mm-yyyy').

But if
select admission_date from iptran where admission_date between to_date('26-10-2002','dd-mm-yyyy');

Results in no rows.

HOw should I re-write this query to retrieve in a minimum of time ?

Thanks in advance
Ravi