How to edit thread time and date?

[nt_loader]

Anyone know how to edit thread/post time and date?

[Replicant]

To the best of my knowledge, in vb5, the only way to modify the date/time of a post is direct database manipulation in the node table, either the created column or the publishdate column (I don't remember which). Date/Times are stored in Unix Timestamp format. It's not difficult, but I would do a DB backup before doing any queries.

[nt_loader]

To the best of my knowledge, in vb5, the only way to modify the date/time of a post is direct database manipulation in the node table, either the created column or the publishdate column (I don't remember which). Date/Times are stored in Unix Timestamp format. It's not difficult, but I would do a DB backup before doing any queries.

That's what I was afraid of, touching the DB always gives me lots of worry. Ill backup and give it try.

Thanks for the heads up

--------------- Added 1451607838 at 1451607838 ---------------

I found the spot with the date in Unix format. How safe is it to edit the table directly? I have a back-up but I don't want to go thru the trouble of a restore if I don't need to.

Do I need to change the date anywhere else?

Happy New Year

[Replicant]

If I remember correctly, I adjusted both the created and publishdate columns (now that I'm thinking about it) in the node table and had zero issues. I can't say for certain that there may or may not be a different column that has to be adjusted ( I didn't make any) but I haven't had any issues with the posts I changed.

[nt_loader]

If I remember correctly, I adjusted both the created and publishdate columns (now that I'm thinking about it) in the node table and had zero issues. I can't say for certain that there may or may not be a different column that has to be adjusted ( I didn't make any) but I haven't had any issues with the posts I changed.

Thanks I appreicate the help, im going to try it...... maybe :erm: