Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

How would I bulk change posting date? I want to change about 20 post publish dates at a time in one click

share|improve this question

2 Answers 2

I just had a similar issue. I used this:

UPDATE `wp_posts` 
SET post_date = "2008-02-13 23:50:30"
WHERE post_status = "publish"
AND post_date >=DATE_SUB(CURDATE(),Interval 5 day)

It is updating the wp_posts table and changing anything published in the last 5 days to the date of 2008-02-13.

share|improve this answer
You you mind making your answer WP compatible? $wpdb->query, $wpdb->posts, etc.? –  kaiser Feb 14 '14 at 2:12

Post date/time can't be changed via the Quick-Edit bulk editor. You might edit the SQL directly, if you're comfortable running a query in PHPMyAdmin. Or, you could search for a Plugin?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.