date format?

[lukeurtnowski]

I have a mysql table field in the date format, it appears like this "yyyy-mm-dd". How do I change the format of that field to read "mm/dd/yyyy"?
Thanks

[Drakla]

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

Look for DATE_FORMAT on that page.

[lukeurtnowski]

I tried this, am I on the right track?
SELECT DATE_FORMAT('$adate', '%d/%m/%Yj');
thanks
$adate is a php variable of the date. Question, do I have to run this query each time the table is updated, or is there a way to change the field format only once?

[lukeurtnowski]

is this right?
$sql="INSERT into activity VALUES('','DATE_FORMAT('$activity_date', '%m/%d/%Y')',
'$activity_description','$c_id','$next_step')";