FROM_UNIXTIME()
FROM_UNIXTIME() functions return values in the connection’s current time zone, which is available as the value of the time_zone system variable.If we use FROM_UNIXTIME() to convert between TIMESTAMP values and Unix time stamp values, the conversion is lossy because the mapping is not one-to-one in both directions.
Syntax:
FROM_UNIXTIME([timestamp])
Example:
select from_unixtime(1174374559);
