---
title: "MySQL timestamp format to human readable"
date: "2009-01-01"
modified: "2013-03-03"
path: "/11-mysql-timestamp-format-to-human-readable.html"
section: "/ramblings"
aliases:
  - "/11"
  - "/11-mysql-timestamp-format-to-human-readable"
  - "/11.html"
  - "/ramblings/11-mysql-timestamp-format-to-human-readable.html"
---

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>