Randomize timestamp in MySQL

To randomize timestamp column in mysql You can use the following statement:

UPDATE yourtable SET 
timestampfield = TIMESTAMPADD(MINUTE, RAND()*60,timestamp_field);

Comments

comments powered by Disqus