Update wordpress post_date to random date with SQL

Replace wordpress post_date to random date,
open phpmyadmin, click SQL, run with this code

UPDATE wp_posts SET post_date = '2014-08-02 00:00:00' + interval rand()*120 day + interval rand()*36000 second

update wp_posts set post_date_gmt = post_date;
update wp_posts set post_modified = post_date;
update wp_posts set post_modified_gmt = post_date;

This can be change all post date, start from 2014-08-02 00:00:00 to 120 days later

This ok tested