Unix Timeformat from phpBB in Mysql Database 1

[lukelukeluke]

Hi everyone.
I have set up a phpBB on my site. In the phpBB, i definied 1 area as the news area. I want to display its content on my main page.

But now i have problems displaying the time of when the thread was posted.
The timeformat in the mysql database is this as integer: "1089048462".
That should be todays or yesterdays date. But i cant see june or 2004 in this, it must be unix formated timecode.
Now does anyone know how php can transform such a code into 7.5.2004?

Thanks for your ideas.
Bye, Luke

 

[danomac]

That is a unix timestamp. The time() function returns that timestamp. You can use getdate() to convert the timestamp.

For example:

$dateArray = getdate(time());
print_r($dateArray);

Will get the current timestamp, break it up into an array and print it out. From there you can build whatever date you need.

 

[lukelukeluke]

thanks alot for the solution. It worked well for me! Here is what i used:

<?php
$unix = 1089096751;
$timestamp = getdate($unix);
echo $timestamp[mday].".".$timestamp[mon].".".$timestamp[year].", ".$timestamp[hours].":".$timestamp[minutes];

 

[sleipnir214]

You can do that or use date() with the second optional parameter.

Date() gives you lots of options for formatting that timestamp as a complex date/time string.



Want the best answers? Ask the best questions!

TANSTAAFL!!