Hello!
So, I'm needing to do the same thing with changing the dates for a couple announcement posts....
And, I guess I'm just not following the instructions well, because it's not working the way I'd like it to.. lol. Sorry for being dense...
First,
I need to run this command:
UPDATE w3t_Posts
SET B_Posted = FROM_UNIXTIME('2003-06-14 20:05:00')
WHERE B_Number = 123456
B number is the post's number, and that date string is what I want the date to turn into?
Or is there math I need to do before? I guess that's where I'm confused.
Any help would be greatly appreciated!
-peter