Monday, February 8, 2016

HOWTO Convert Unix timestamp into human readable date using MySQL

Just as easy as the typing the following in MySQL:

mysql> select from_unixtime(1445506564);
+---------------------------+
| from_unixtime(1445506564) |
+---------------------------+
| 2015-10-22 11:36:04       |
+---------------------------+
1 row in set (0.00 sec)

mysql>