campo date mysql

[piero.mac]

select *, date_format(campo_data, '%d/%m/%Y') as data_it
from .....