Convert Unix timestamp into human readable date using MySQL

Posted 2 years ago

In order to convert a column from a timestamp to a human readable date in sql you can use the “from_unixtime()” function.


SELECT title, from_unixtime(entry_date) FROM table

You can go one step further and format the date to how you’d like.


SELECT title, from_unixtime(entry_date, '%Y %D %M %h:%i:%s') FROM table