Help with timestamp

[Padgoi]

I'm trying to pull a date from my mysql database.  I'm pulling the info correctly but it's showing as a timestamp (string of numbers).  How do I get it to display in the correct date format?

 

Here's the snippet:

 

	echo "<font color='blue'>The last topic posted in is</font><a href='".$INFO['board_url']."/index.php?showtopic=".$lastpost[1]."&view=findpost&p=".$lastpost[0]."'><font color='red'>".$topics[0]."</font></a><font color='blue'>by</font><a href='".$INFO['board_url']."/index.php?showuser=".$lastpost[3]."'><font color='red'>".$lastpost[2]."</font></a><font color='blue'>in</font><a href='".$INFO['board_url']."/index.php?showtopic=".$lastpost[1]."&view=findpost&p=".$lastpost[0]."'><font color='red'>".$z[0]."</font></a>at <font color='red'>".$lastpost[4]."</font>";

 

The very last part ".$lastpost[4]." is the timestamp portion.  How do I get that to show correctly?

 

The query that is pulling the data from the dbase is:

 

		$q = "SELECT pid, topic_id, LEFT(author_name, 15), author_id, post_date from ibf_posts order by pid desc limit 1";

 

where post_date is the timestamp.

 

Any help would be greatly appreciated!

[F1Fan]

Use the strtotime() function. This will convert the timestamp to a PHP time stamp, as in the time() function. Then, use the date() function to format it as you wish.

 

http://www.w3schools.com/php/php_ref_date.asp

[fenway]

STR_TO_DATE() works too.