Do you store date or time values in MySQL?

Would you like to know how to avoid many possible types of pain, most of which you cannot even begin to imagine until you experience them in really fun ways?

Then this blog post is for you. Here is a complete set of rules for how you can avoid aforementioned pain:

  1. All date and time columns shall be INT UNSIGNED NOT NULL, and shall store a Unix timestamp in UTC.

Enjoy all the spare time you’ll have to do actually useful things as a result.

Done! Now Read These:

Speaking at Percona Live 2014

Percona Live is the best MySQL conference, period.

Immutability, MVCC, and Garbage Collection

Immutable databases seem elegant but create difficult tradeoffs, sometimes resolved via short-term immutability.

How is the MariaDB Knowledge Base licensed?

It isn't clear whether the MariaDB knowledge base's license addresses problems the authors have criticized in the MySQL documentation.