Advertisement
niammuddin

Acak tanggal wordpress sql

Apr 9th, 2018
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. UPDATE wp_posts SET post_date = DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP('2016-03-01') + FLOOR(0 + (RAND() * 63072000))), '%Y-%m-%d');
  2. UPDATE wp_posts SET post_date_gmt = DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP('2016-03-01') + FLOOR(0 + (RAND() * 63072000))), '%Y-%m-%d');
  3. UPDATE wp_posts SET post_modified = DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP('2016-03-01') + FLOOR(0 + (RAND() * 63072000))), '%Y-%m-%d');
  4. UPDATE wp_posts SET post_modified_gmt = DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP('2016-03-01') + FLOOR(0 + (RAND() * 63072000))), '%Y-%m-%d');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement