SELECT *, DATE_FORMAT(campo,'%d-%m%Y') as new_data from... etc.