$date_format=date("m:d:y",$time_stamp); // formats timestamp in mm:dd:yy
or inside MySQL, for example:# $select = array();
# $select[] = "MONTH(timeStamp) AS theMonth";
# $select[] = "DAY(timeStamp) AS theDay";
...then print it out with PHP:
<?php
echo $results["theMonth"]."/".$results["theDay"];
?>
The rest you can fing in PHP docs under date() function or in MySQL docs under TIME or TIMESTAMP$timestamp = "20110307121543";
$newdate = sprintf("%02s-%02s-%02s", substr($timestamp,0,4),substr($timestamp,4,2),substr($timestamp,6,2));
echo date('F d, Y', strtotime($newdate));