Skip to content

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);