Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Answer: Placeholders and NOW()

by runrig (Abbot)
on Aug 15, 2002 at 02:36 UTC ( #190283=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > Placeholders and NOW() - Answer contributed by 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);

Replies are listed 'Best First'.
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())
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 chanting in the Monastery: (4)
As of 2016-10-01 23:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?






    Results (9 votes). Check out past polls.