Most of you are all aware of the lack of microsecond support in MySQL.
This has been a long-standing issue:
http://bugs.mysql.com/bug.php?id=8523
*cringe* .. sorry, just my normal reaction after seeing that bug, err feature request, again and again over the past 6+ years ..
However, I think many people do not realize that microseconds are supported by MariaDB in version 5.3+, which for all intensive purposes is a drop-in replacement for MySQL.
So if you need microsecond support for MySQL, you should definitely check out MariaDB.
“In MariaDB 5.3, the TIME, DATETIME, and TIMESTAMP types, along with the temporal functions, CAST and dynamic columns, now support microseconds. The datetime precision of a column can be specified when creating the table with CREATE TABLE”
Also:
“Generally, the precision can be …
[Read more]