my $sth = $dbh->prepare(q{
    INSERT INTO t ( foo, bar, time ) VALUES (?, ?, NOW() )
});

$sth->execute($foo, $bar);