How do I change the time of the post?

[user 1-2-3]

After conversion from UBB I've got the following problem: posts with the time 12.xx AM were converted to 12.xx PM. This caused the posts' order to change.

Is there any way to change the post time manually?

[Steve Machol]

There is no function or feature to do this. They would each have to be changed manually in the database.

[user 1-2-3]

Please advise how can I do that? Unfortunately I'm not quite familiar with databases. Which software do I need for this?

[MJM]

Can't help you out there, but there is a fabulous hack at vb.org which makes it very easy to change the time of a post, and much more,
Advanced Editing Options For Mods & Admins

[Steve Machol]

You need to go into phpMyAdmin and modify the dateline column in the post table and enter the unix timestamp that you want. You can use this online tool to convert dates and times to Unix Timestamps:

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

Just remember to enter in the GMT values for the date and not the date and time in your specific timezone.