how to reset the date for all the old posts

  • Resolved nemdil

    (@nemdil)


    13 years, 10 months ago

    using a blogging software i posted my first posts in future dates like 2014 and above, now when i noticed the problem and i started to post in the current date, all my new posts don’t appear in the front as a new posts because of the date. how can I reset the date for all my post to the current date and time?

    thank you

Viewing 3 replies - 1 through 3 (of 3 total)

  • If you have just a dozen or so, you can set new (correct) dates in the quick edit mode for each post in turn.

    If you have too many to attempt manually, then you’re best bet is a bit of MySQL in phpMyAdmin. My MySQL skills are only amateur, so you’ll need someone else to guide you for that approach.

    Thread Starter nemdil

    (@nemdil)

    Thank you, I will try MySQL

    Thread Starter nemdil

    (@nemdil)

    I found it and i done it, 21000 post dates changed from 2014 and above to current date in 2 seconds.

    this is the code :

    Run SQL query/queries on database

    ———————————————————————–
    UPDATE wp_posts
    SET post_date = ‘2011-02-05’,
    post_date_gmt = ‘2011-02-05’
    ———————————————————————–

    change the date you want.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘how to reset the date for all the old posts’ is closed to new replies.