SELECT DATE_FORMAT(campo_timestamp, "%d-%m-%Y") AS Data FROM tabella;