Convert timestamp to date in MySQL query October 5, 2022 by Tarik DATE_FORMAT(FROM_UNIXTIME(`user.registration`), '%e %b %Y') AS 'date_formatted'