Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sysdate and date columns
Hi;
From what I understand,
select *
from <table>
where trunc(date1) = trunc(sysdate);
should work.
Doug
--