Fix for MAMP when MySQL is not starting
This just helped me out, so this is for those having the same problem, but mainly posted here so I have a reference of it!
This just helped me out, so this is for those having the same problem, but mainly posted here so I have a reference of it!
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.
