Log in

View Full Version : question about changing date on posts


shibby2
02-18-2009, 07:36 PM
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
02-18-2009, 07:41 PM
Yes, phpmyadmin, be careful and backup before touching it.

shibby2
02-18-2009, 07:53 PM
awesome, thanks! :) I didnt even think about phpmyadmin lol

shibby2
02-20-2009, 02:36 AM
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
02-20-2009, 02:49 AM
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
02-20-2009, 03:07 AM
Awesome, thanks so much! :)