select *, date_format(campo_datetime, '%d/%m/%Y') as data
from tabella