Possible to change Wordpress comment timestamps?

April 22, 2011 2:19 AM

Is it possible to change timestamps on comments in Wordpress?

I'm doing a project where I'm porting over an old discussion board onto a P2-themed Wordpress installation. I can post and comment as different users, and I can publish posts to the past, but I can't publish comments to the past.

Google Fu availed me nothing. Help?

posted by dubadubowbow to Computers & Internet (3 answers total)

If this is a one-off kind of thing you can simply edit the database. If you have phpMyAdmin installed this is quite simple and very point-and-click, just open up the wp_comments table, find the relevant comment, and edit the comment_date_gmt field.
posted by Rhomboid at 2:57 AM on April 22, 2011

You can actually also change the time stamp on the individual comment too. Go to edit the comment, and where the date is in bold, there's a little edit button right beside that. I had to utilize that some when I consolidated my blogs of yore.
posted by Kronur at 5:53 AM on April 22, 2011

If you just want to change the date of few comments then look at the method 'Kronur' suggested or try phpmyadmin.

If you want to migrate all the old comments with the old timestamps then create a db migration script (without using wordpress import process)
posted by WizKid at 8:49 AM on April 22, 2011