How do I generate a random time interval and add it to a mysql datetime using php?
Posted
by
KeenLearner
on Stack Overflow
See other posts from Stack Overflow
or by KeenLearner
Published on 2011-01-15T06:11:24Z
Indexed on
2011/01/15
6:53 UTC
Read the original article
Hit count: 222
I have many rows in mysql table with datetime's in the format of:
2008-12-08 04:16:51 etc
I'd like to generate a random time interval of anywhere between 30 seconds, and 3 days and add them to the time above.
a) how do I generate a random time between 30 and 3 days?
b) how do I add this time to the date time format above?
I imagine i need to do a loop to pull out all the info, do the math in php, and then update the row...
Any ideas?
© Stack Overflow or respective owner