SELECT
  from_unixtime(timestamp) 
FROM 
  your_table