mysql date format unix timestamp
snippet in sql

mysql date format unix timestamp

user576

SELECT
  FROM_UNIXTIME(timestamp) 
FROM 
  your_table;