question about changing date on posts

[shibby2]

Hi, I have a quick question...I wanted to add a couple posts from another one of my forums to another forum (I was just going to copy&paste them into new posts), but I want to display the actual date they were posted (a couple years ago)....so, is there any way I can manually change the time and date of a couple posts?

Thanks!

[snakes1100]

Yes, phpmyadmin, be careful and backup before touching it.

[shibby2]

awesome, thanks! I didnt even think about phpmyadmin lol

[shibby2]

Question...which table would I adjust the date in? I clicked on the 'post' table, but under dateline it's just a number like "1235026915".

Any ideas?

[private_ale]

Originally Posted by shibby2

Question...which table would I adjust the date in? I clicked on the 'post' table, but under dateline it's just a number like "1235026915".

Any ideas?

That's called UNIX time.
Just convert human time to unix time and replace I suppose.

http://www.onlineconversion.com/unix_time.htm

[shibby2]

Awesome, thanks so much!