Comparing the "date" (omitting the time)

Hello,

I need everyones help. The query below works, but it does not retrieve a row that is = to the sysdate. The reason is because it also uses the TIME to compare the with the sysdate. Can someone show me how to write a sql to omit the time from the date in the date column. Thanks!

SELECT * FROM MYTABLE WHERE date >= sysdate;

use trunc() on both sides of the equation....

select *
from myTable
where trunc(date) >= trunc(sysdate);