Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re^2: 5 minutes of time

by weierophinney (Pilgrim)
on Jun 04, 2005 at 12:15 UTC ( #463516=note: print w/replies, xml ) Need Help??


in reply to Re: 5 minutes of time
in thread 5 minutes of time

While I agree with this to an extent, MySQL also has a ton of functions for modifying and comparing dates. The TIMESTAMP type tends to be useless for what the OP is looking for -- as it gets updated each time the record is updated. However, DATETIME does not, and it becomes fairly trivial to write SQL that can do date/time comparisons on such fields. The reason I would prefer to use the SQL over using perl in this instance is that it's portable; if I choose to use another language, I can use the same SQL for doing the comparison.

I leave it up to the OP to look up the date and time functions; they're very well documented on the MySQL site. (Which is where s/he should have started looking, really... :-)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://463516]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2020-12-04 08:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (58 votes). Check out past polls.

    Notices?