select date_format(campo_data,"%d-%m-%Y") as data_it from tabella