my $offset = 65;
my $time = $offset * 86400;

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