XF 1.2 Date system

[Tyrone Chicken]

I need to grab upgrade dates from the db, could anyone explain the format for this? this is whats in the db 1387670400 and it is meant to be Dec 22, 2013.

 

[Jeremy]

They are stored as a UNIX timestamp, which allows conversion using time zones, etc. You'll need some sort of code to convert them:
http://en.wikipedia.org/wiki/Unix_time

 

[Rigel Kentaurus]

You can use this page to convert it:
http://www.epochconverter.com/



In your database

SELECT from_unixtime(post_date) FROM xf_post;

will give you the formatted date