View Full Version : A strange timestamp do not convert

Rodrigo Ferrari
08-28-2006, 04:11 PM

I'm using phpbb, and the phpbb store the date with timestamp, but this timestamp is sotered with the GMT. So the problem is this:

- I would like to create a colun at my website with the recent's topics at a board in my phpbb, so i do it right, everything was ok, but when i want to display the date from the topic, it returns a timestamp format the: 1133027084
- At the php code, i write:

$resultNovidades = mysql_query("SELECT forum_id, topic_poster, topic_replies, topic_id, topic_title, topic_time as data FROM phpbb_topics WHERE forum_id = '19' ORDER BY topic_time DESC LIMIT 9", $connection) or die("Não foi possível conectar, erro em Novidades.");
$recordcountNovidades = mysql_num_rows($resultNovidades);
<?echo $row['data']?>

It returns the timestamp, how can i show this date with the (GMT -3) at a goof format as d/m/y???/

Thanks a lot and sorry about my english!

08-28-2006, 04:37 PM
Use date_format in your query.