SELECT theTimeStamp, FROM_UNIXTIME(theTimeStamp) AS readableDate code example
Example: mysql date format unix timestamp
SELECT
FROM_UNIXTIME(timestamp)
FROM
your_table;
SELECT
FROM_UNIXTIME(timestamp)
FROM
your_table;