MyBB Community Forums

Table SQL: mybb_posts colum: dateline (example content: 1269609897) - what is it? Is this the time and date? If yes - how to convert to the correct time and date format?

It's a timestamp, number of seconds since 1st Jan 1970. 1269609897 is Fri, 26 Mar 2010 13:24:57. Use a site like this to convert it, or you can use PHP:

$time = 1269609897;
$friendly_time = date("D, j M Y H:i:s", $time);
echo $friendly_time; // outputs: Fri, 26 Mar 2010 13:24:57

Big Thanks!