PHPBB forum, how do i get the date?

In the mysql database the date in PHPBB forum databases are just numbers.

[GamingLoft]

K i need to find out how to find out the dates of posts and such and echo them onto another page, im trying to integrate my site with a PHPBB forum

Version: phpBB 2.0.22

The column is called post_time
"i guess it has both the time and date in there"

here is the number(or so called time): 1195867347

so yeah, if anyone knows, what the formula to get the time and date out of that, then please tell me, or even if you can tell me in which file i could find this. k thanks a bunch.

[eelixduppy]

That is a timestamp. To convert it to something you are more familiar with, you have to use the date function. So something like this:

echo [url=http://www.php.net/date]date[/url]("F j, Y, g:i a",1195867347);