Personal Knowledge Management

Mysql convert timestamp to date

Posted on August 20, 2019, 2:49 pm, by admin, under mysql.

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

Comment (RSS) | Trackback