Description:

I'm using placeholders (in DBI/MySQL) on a set of INSERT statements;
however, when I try to fill a "?" placeholder with the value of NOW(), I just get the plain string "NOW()" in my data. Is there any way to tell the DBI/MySQL that the NOW() is supposed to be a current time function and not a plain string?

sub NOW {
# Return current time in whatever format it
# Needs to be in
}
$sth->execute(NOW());
[download]

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

$sth->execute($foo, $bar);
[download]