[SOLVED] Easy question about date format

[izbryte]

How do I format the date to 'm.d.y' within my results?

 

<?php

$query  = "SELECT title, employer, location, date FROM jobs";

$result = mysql_query($query);

 

while($row = mysql_fetch_array($result, MYSQL_ASSOC))

{

echo "

  <tr>

    <td><b>{$row['title']}</b> <br>{$row['employer']}</td>

    <td>{$row['location']}</td>

    <td>{($row['date']}</td>

  </tr>";

}

?>

 

Sorry if I'm a bonehead!

[Barand]

Depends on what column type you defined for the date field

[izbryte]

DATETIME

[Barand]

echo date ('m.d.y', strtotime($row['date']));

[izbryte]

thank you so much!