Select date_format(data, '%Y-%m-%d') as data_formatada From ......
function FormatDate($date,$format){
return date($format,strtotime($date));
}
$date="2007-10-28 23:18:00";
echo FormatDate($date,"Y-m-d");
//imprime 2007-10-28
echo FormatDate($date,"Y-M-D");
//imprime 2007-Oct-Sun
echo FormatDate($date,"F j, Y, g:i a");
//imprime October 28, 2007, 11:18 pm
PHP:function FormatDate($date,$format){ return date($format,strtotime($date)); }