MySQL timestamp format to human readable

Written by Peter Davies on .

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