Date matching for better performance.

Dear,
  I have one column trans_date of DATE type.How should I match trans_date
column?
e.g If I want to match 01-April-2007 then
    by which data retrive fast.

    WHERE trans_date='2007-04-01';
     OR
    WHERE trans_date='04-01-07';
     OR

Monalee Bhandge wrote:

> 
> Dear,
>   I have one column trans_date of DATE type.How should I match
> trans_date column?  e.g If I want to match 01-April-2007 then
>     by which data retrive fast.
> 
>     WHERE trans_date='2007-04-01';
>      OR
>     WHERE trans_date='04-01-07';
>      OR
>     WHERE trans_date='04-01-2007';

It makes no performance difference which date format you use as long as
you use a format that InterBase understands. If you are running a query
from within a program it is best to use a parameter for the date to
avoid date format problems.

--