MySQL: Convert INT to DATETIME

datetime, mysql

Solution

`FROM_UNIXTIME()`

Problem

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.)

Original source