Convert timestamp to date in MySQL query

SELECT DATE_FORMAT(FROM_UNIXTIME(`registration`), '%d %b %Y') AS 'date_formatted' FROM users


Output: 30 Dec 2021