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

Post a Comment

Your email is never published nor shared. Required fields are marked *