Showing entries 1 to 2
Displaying posts with tag: mysql microsecond (reset)
Glad to See Microsecond Support in both MariaDB and MySQL Now

As you may or may not know, MariaDB has supported microseconds in version 5.3 for several months already.

And now MySQL has added microsecond support in version 5.6 (5.6.4, specifically).

For more details on MariaDB microseconds, please refer to this page:

http://kb.askmonty.org/en/microseconds-in-mariadb

And for more details on MySQL microseconds, see “Fractional Seconds Handling” on the following page:

http://dev.mysql.com/doc/refman/5.6/en/news-5-6-4.html

From what I can tell, the implementation looks largely to be the same (at least from a user perspective), in that if the fractional part is given, it must be an integer number 0 to 6. And if no precision is …

[Read more]
Microseconds and MariaDB

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]
Showing entries 1 to 2