Need assistance with the date format of this query
How can I get the date to display in US Format?
global $pageObject;
$data = $pageObject->getCurrentRecord();
$sql = "SELECT * FROM
cases where company =".$data["companyId"]." ";
$rscases = CustomQuery($sql);
echo "<table width='80%' border='1' bordercolor='#C0C0C0' cellpadding='5' >";
echo "<tr>";
echo "<td> Case</td>";
echo "<td> Date</td>";
echo "<td> Start Time</td>";
echo "<td> End Time</td>";
echo "<td> Repair Type</td>";
echo "</tr>";
while($data1=db_fetch_array($rscases))
{
echo "<tr><td> <a href=cases_view.php?editid1=".$data1["caseId"].
">". $data1["case"]."</a></td>";
echo "<td> ". $data1["date"]."</td>";// NEED THIS TO DISPLAY MM/DD/YYYY
echo "<td> ". $data1["time"]."</td>";
echo "<td> ". $data1["end_time"]."</td>";
echo "<td> ". $data1["repairtype"]."</td></tr>";
}
echo "</table>";