select *
from tabname
where trunc(dtcol) = trunc(sysdate)
或者：
select *
from tabname
where dtcol >= trunc(sysdate) and dtcol < trunc(sysdate) + 1
select *
from tabname
where trunc(dtcol) = trunc(sysdate)
或者：
select *
from tabname
where dtcol >= trunc(sysdate) and dtcol < trunc(sysdate) + 1
