Select random date
I use this for insert records into a queue. To avoid overload one day, just split the records up over a number of days ….
now() + INTERVAL rand()*2 day + INTERVAL 2 hour
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}
Categories: MySQL
I use this for insert records into a queue. To avoid overload one day, just split the records up over a number of days ….
now() + INTERVAL rand()*2 day + INTERVAL 2 hour