Re: Help: Query Against an Indexed Date Field

Thanks to Jonathan and Thomas for their responses.

For those interested, the solutions were to use:

    select .. from .. where adate between to_date('22-nov-98') and

        to_date('22-nov-98') + 86399/86400

or

    select .. from .. where adate between to_date('22-nov-98') and

        to_date('22-nov-98 23:59:59','dd-mon-yy hh24:mi:ss')

Both variations on a theme. Received on Sun Nov 22 1998 - 09:45:43 CST