3 ms·
The last MySQL limitation to bite me was that time columns are truncated to whole-second granularity - no milliseconds or microseconds. http://bugs.mysql.com/b
by samstokes 16y ago
The last MySQL limitation to bite me was that time columns are truncated to whole-second granularity - no milliseconds or microseconds.
http://bugs.mysql.com/bug.php?id=8523 http://bugs.mysql.com/bug.php?id=8523
If you want sub-second granularity, the advice is to store milliseconds-since-epoch as a BIGINT and have your application convert it to a time:
http://feedblog.org/2007/05/26/why-doesnt-mysql-support-millisecond-datetime-resolution/ http://feedblog.org/2007/05/26/why-doesnt-mysql-support-mill...
- pbh 16y agoI had the same problem (and, really, 5 years?), but "solved" it at the time with ISO8601 strings. They sort, they're standard, they support microseconds, they're fairly common in web services. Slower than a reasonable native type though, obviously.