Converting time() after retrevial

[Superman702]

Newbie question... 

 

I have a form in which I submit time() into an INT on MySQL.

 

After I retrieve that table with the old UNIX Timestamp on it, how do I convert it from .$info['timestamper'] . (which holds the timestamp) into a date and time output? (i.e. 01:05:05 PM 12/25/2010)

 

My Current Code:

$mins = time()-60*60*24*3; //Last 72 hours
$result = mysql_query("SELECT * FROM messages WHERE `timestamper` > '$mins'");
$num_rows = mysql_num_rows($result);
echo "<CENTER><table border cellpadding=3><TR><TH>Message</TH><TH>Sent By</TH><TH>Time</TH></TR>";
while($info = mysql_fetch_assoc($result)){
Print "<tr><TH>".$info['display'] . "</th> <th>".$info['username'] ."<TH>".$info['timestamper'] ."</TH></TR>"; 
}

[MasterACE14]

date()

// Prints something like: Monday 8th of August 2005 03:12:46 PM
echo date('l jS \of F Y h:i:s A');

 

date('h:i:s A m/d/Y',$info['timestamper']); // this will do the trick

[Superman702]

Worked like a charm.

 

I read it on PHP, but I thought since it was already an existing variable, I couldn't plug it into a date() command. Guess I was wrong. Thanks for your help!

[Pikachu2000]

Or you could do it directly in the query.

SELECT FROM_UNIXTIME(timestamper, '%h:%i:%s %p, %m/%e/%y') AS formatted_date, * FROM messages WHERE `timestamper` > '$mins'