MyBB Community Forums
[General] Change Date & Time of a Thread / Post - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [General] Change Date & Time of a Thread / Post (/thread-234853.html)

Change Date & Time of a Thread / Post - flash99 - 2022-02-03

Hi,

I wanted to find out is there a plugin or way to change the Date & Time of a Thread / Post?

In the DB, there is the below format

Dateline
1638385464
1638386476


I want to do a drip feed of content.

Thanks

RE: Change Date & Time of a Thread / Post - [ExiTuS] - 2022-02-03

There's no human-readable date/time within MyBB.
This timestamp is the only source that needs to be converted.

E.g. use a UNIX Timestamp converter:
https://www.unixtimestamp.com/

To update the dateline filed, you can try this SQL function to auto-convert a date:
UPDATE mybb_posts SET dateline = UNIX_TIMESTAMP("2022-02-01") WHERE ...;

[ExiTuS]

RE: Change Date & Time of a Thread / Post - flash99 - 2022-02-05

Thanks ExiTuS,

That info helped a lot.