MySQL: Convert INT to DATETIME

Question

I have a UNIX-type timestamp stored in an INT column in MySQL. What is the proper way to retrieve this as a MySQL DATETIME?

(I found the answer when re-scanning the MySQL Date functions, but didn't see the answer on SO. Figured it should be here.)

Answer 1

FROM_UNIXTIME()

Answer 2

select from_unixtime(column,'%Y-%m-%d') from myTable;