meteoracle

Many, many times have I had to convert a MySQL timestamp (YYYY-MM-DD HH:MM:SS) into a more human readable format directly from a MySQL query. I’ve always done this with DATE_FORMAT.

Today, however, I needed to do something a little different. A Unix formatted timestamp held in the database needed to be converted to a human readable format.

And this is the answer I came across, the rather useful FROM_UNIXTIME.