Re: Placeholders and NOW()

[runrig]

yes:

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

But I suspect NOW() is a function in your particular database, in which case you wouldn't use a placeholder, and you would just put a literal NOW() in your SQL statement.

Example:

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

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

[dws]

Instead of using a parameter that you'll bind at execute() time to the current time, include it instead directly in the query. For example, INSERT INTO t (msg, ts) VALUES(?, NOW())