Link Search Menu Expand Document

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