Randomize timestamp in MySQL

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

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

Comments

comments powered by Disqus