To randomize timestamp column in mysql You can use the following statement:
UPDATE your_table SET timestamp_field = TIMESTAMPADD(MINUTE, RAND()*60,timestamp_field);
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