Convertir fecha timestamp a date mysql

Consulta

SELECT type,created,from_unixtime(created, '%Y-%m-%d') as fecha
FROM `node_field_data`