Re: sysdate and date columns

That will prevent the usage of an index on column 'DATE1'. It may be better to write:

select *
from <table>
where date1 >= trunc(sysdate)
and date1 < trunc(sysdate + 1)

Marc

Doug O'Leary wrote in message ...
>Hi;
>
>From what I understand,
>
>select *
>from <table>
>where trunc(date1) = trunc(sysdate);
>
>should work.
>
>Doug
>--
>==============
>Douglas K. O'Leary
>Senior System Admin
>dkoleary_at_mediaone.net
>==============
Received on Thu Jan 20 2000 - 00:42:35 CST