FROM_UNIXTIME
Convert Unix time (LONG in epoch seconds) to DATETIME (YYYY-MM-DD HH:mm:ss).
Syntax
FROM_UNIXTIME(<unix_time>)
| Parameter | Description |
<unix_time> | The UNIX epoch time that is to be converted. |
Example
SELECT
FROM_UNIXTIME(1493971667);
Returns: 2017-05-05 08:07:47