SQL query to convert timestamp to date readable format, which is stored in MySQL database.
SELECT t
.*, DATE_FORMAT(FROM_UNIXTIME(t
.enteredOn
), ‘%e %b %Y’) AS formated_date
FROM tbl_sample
AS t
;
For the detailed reference on DATE_FORMAT() and FROM_UNIXTIME()