EmergencyEMERGENCY? Get 24/7 Help Now!

Upgrading to MySQL 5.7, focusing on temporal types

 | April 27, 2016 |  Posted In: MySQL, Percona Server

temporal types

In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters can be set down to microsecond granularity. Obviously, this means format changes, but why […]

Read More

Recovering temporal types in MySQL 5.6: TIME, TIMESTAMP and DATETIME

 | July 16, 2013 |  Posted In: Insight for DBAs, MySQL

MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME can have a fractional part. To create a field with subseconds you can specify precision in brackets: TIME(3), DATETIME(6) etc. Obviously, the new feature requires the format change. All three types may now have a […]

Read More