Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
There's more than one way to do things
 
PerlMonks  

Answer: Placeholders and NOW()
( #190283=categorized answer: print w/ replies, xml ) Need Help??

Q&A > database programming > Placeholders and NOW() contributed by runrig

yes:

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

[download]
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);

[download]

Comment on Answer: Placeholders and NOW()
Select or Download Code
Re: Answer: Placeholders and NOW()
by dws (Chancellor) on Aug 15, 2002 at 02:48 UTC
    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())
[reply]
[d/l]
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (14)
As of 2013-06-20 07:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How many continents have you visited?









    Results (680 votes), past polls