How can I batch change timestamp for all the posts?

  • If I want to batch change the timestamp for all of my posts (one category would the best) to be 3 months later, how can I do that? Is there a script or sql file could do that?

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

  • not that im aware of – you can do it in phpmyadmin though, easily enough.

    Thread Starter karmasamten

    (@karmasamten)

    Do you know how I can do that via phpmyadmin? I know a little of how to use phpmyadmin, but I don’t know how to write a proc.
    Thanks

    you dont indicate what version of wp you are using — that might make a difference in the query, but heres a start.

    UPDATE 'wp_posts' SET post_date= '2007-08-15 10:30:11', post_date_gmt='2007-08-15 10:30:11'

    change the dates as neccessary, and realize that I havent provided any filtering on the posts — that will change them all.

    Thread Starter karmasamten

    (@karmasamten)

    Thanks a lot!
    My version is 2.2.
    How can I set a filter? If I want to update the post_date for all the posts under one category, to be 3 months later, how can I achieve that? For example,

    The post_date is 2007-08-15 becomes 2007-10-15
    The post_date is 2007-08-16 becomes 2007-10-16
    The post_date is 2007-08-17 becomes 2007-10-17
    etc.

    Thanks a lot

    whooami, any update to this? i want to do exactly the same thing.

    thank you very much.

    why are you doing this? You have a thread – look in it.

    The reason im doing it is because i have built up a ton of content in my blog but it’s just starting to get traffic… so i want to push all the old content forward.

    If you are asking why i posted in this thread its because in my initial thread located here: https://www.ads-software.com/support/topic/133064 you linked me to this one.

    why are you doing this means why are you talking in TWO threads. Go read your thread.

    Could anyone help KarmaSamten and I with this?

    thank you!

    Is there any information we could add to this thread to make it more clear/relevant?

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘How can I batch change timestamp for all the posts?’ is closed to new replies.