XF 1.4 Precise time of message being posted?

[compactabt]

Hello!

As part of a police enquiry relating to the safety of one of my forum's members I've been asked if I can supply to the time, to the second, that a message was posted on my forum.

Does anyone know if there's a way of finding this out, either in the normal admin capacity or by accessing the database?

Thanks in advance!

 

[AndyB]

Use phpMyAdmin.

table = xf_post

field = post_date

post_date is the exact time the post was made in Unix timestamp. Use this link to convert to human readable:

http://www.epochconverter.com/

 

[compactabt]

That's so helpful. Thanks very much!

 

[Paul B]

You can do it with a query using:

SELECT FROM_UNIXTIME(post_date)
FROM xf_post
WHERE post_id = 1

Change the post_id (1) to the actual post.

The output is in the format yyyy-mm-dd hh:mm:ss