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()
