Re: Date Search (fromdate TO todate)

Jim Kennedy wrote:

>select ... from mytable where to_date('01/15/2001','mm/dd/yyyy')
><=theDateColumn and to_date('01/20/2001','mm/dd/yyyy') >=theDateColumn

Much more Simple:

SELECT...
FROM table
WHERE datefield BETWEEN to_date('01/15/2001','mm/dd/yyyy') AND to_date('01/20/2001','mm/dd/yyyy');

With this you don't have to use >,<,<=,>= and you have to type the name of your datefield only one time, insted of typing it twice.

Volker Received on Sat Oct 06 2001 - 15:59:23 CDT