mysql timestamp to date

DATE_FORMAT(FROM_UNIXTIME(created), '%d/%m/%Y')
DATE(FROM_UNIXTIME(created))