Sysdate And To_date

[rajabalachandra]

select *
from tablename
where date_field > sysdate- 7
and date_field < sysdate;