my $sth = $dbh->prepare_cached(<<SQL);
select host
from log
where to_days(now()) - to_days(stamp) > ?
SQL
$sth->execute(7);