My notes, things I have learned, and documentation I have created.

This will output two columns. One is the original time as an integer and the second as YYYY-MM-DD hh:mm:ss.

select TIMESTAMP, from_unixtime(TIMESTAMP) from my_table;