MySQL timestamp format to human readable

Ok, I have no idea where this originally came from but its been very useful the past few years for converting the standard "0000-00-00 00:00:00" format into something useable (and that the client accepts):

https://gist.github.com/1037627