con mysql
http://dev.mysql.com/doc/refman/5.0/...on_date-format
codice:
SELECT DATE_FORMAT(  '2011-01-23 13:32:24',  '%d/%c/%Y %T' ) AS compleanno
con php
Codice PHP:
date('m/d/Y h:i:s', strtotime("2011-01-23 13:32:24"));