Mysql convert timestamp to date

SELECT DATE_FORMAT(FROM_UNIXTIME(yourfield), '%e %b %Y') FROM yourtable;

Leave a Reply