SELECT *,date_format(nome_campo, '%d-%m-%Y %H:%i:%s') as data_it FROM tua_tabella
per maggiori info:
http://dev.mysql.com/doc/refman/5.0/...on_date-format