Date_format() ? Question help

If I have a MySQL table field of my one date with this format (09-13-2011 11:22:43), as I do for PHP to print with this format (09/13/2011 11:22:43) Sorry my ignorance I searched the php.net site b开发者_JAVA技巧ut can not find something about my request, Apologies.

---

$mysql_date = '09-13-2011 11:22:43';
$date = DateTime::createFromFormat('m-d-Y H:i:s', $mysql_date);

echo $date->format('m/d/Y H:i:s');

---

Use:

date( "m/d/Y h:i:s", UNIX_TIMESTAMP($fieldname));

If your field is already timestamp use the following:

date( "m/d/Y h:i:s", $fieldname);

---

I may be wrong in saying this but I don't think theres a standard way in doing so, unless you want to save the date/time as a unix_timestamp. If you do then you can format the time in however you want using the php date() function. If you aren't then you can always use something like str_replace() on the times to get them to the format you want or even use regex if your feeling adventurous

---

MySQL's DATE columns format is fairly irrelevant. Just use DATE_FORMAT() to convert the date to a string that suits your needs.