Mysql unix timestamp to date

Mysql unix timestamp to date:  FROM_UNIXTIME(unix_timestamp) function.

Example:
SELECT *, FROM_UNIXTIME(time_expire) texp FROM _queue ORDER BY texp;