Format Date from table

[markkski]

I have a field in a table that has a date in it. Each record will have a different date all formated like 2003-03-17. When outputting this field how can i format it like 3/17/03. I tryed a couple different ways but it was all for the now() time and i want to just format an existing date from my table.....

Thanks

Mark

[cgraz]

SELECT *, DATE_FORMAT(date_field, '%m/%d/%Y') AS thedate FROM your_table

Cgraz

[cgraz]

Just to clear up any confusion

$query = mysql_query("SELECT *, DATE_FORMAT(date_field, '%m/%d/%Y') AS thedate FROM your_table") or die(mysql_error());

while($row = mysql_fetch_assoc($query)) {

// print the date
echo $row["thedate"] . "<br>";

}

This will return the records into an array called $row, which you can then access using the associative array -> $row["thedate"] also make sure to replace date_field with the date field in your database.

Cgraz