Bug #13414 It should be possible to have time granularity down to the milliseconds
Submitted: 22 Sep 2005 22:57 Modified: 22 Sep 2005 23:13
Reporter: Mike McAngus Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:4.1.14 OS:Microsoft Windows (Windows XP)
Assigned to: CPU Architecture:Any

[22 Sep 2005 22:57] Mike McAngus
I have determined that:

1.  None of the time retrieval functions (NOW(), CURTIME()) returns the decimal portion of the time.
2.  Although the MySQL Query Browser shows DATETIME with a 6 places to the right of the decimal point, there appears to be no way to set those digits.

I did my testing using MySQL 4.1.14 on Windows XP with InnoDB enabled.

It should be possible to store some type of date&time field down to the millisecond level at least (this would be hardwar and OS dependent) and it should be possilbe for the functions that return time information to return the millisecond or microsecond portion of the time.

How to repeat:
Create Tables with DATETIME and TIMESTAMP columns, and try to insert date and time values containing seconds digits to the right of the decimal point.

Retrieving the values using <colName>+0 showed me that TIMESTAMP columns do not have any digits to the right of the decimal point, and that DATETIME columns do have 6 digits to the right of the decimal point, but they are always zeroes.
[22 Sep 2005 23:13] MySQL Verification Team
This feature was already discussed in other bug report not exactly with
the same Sypnopsis and it is our TODO not for 4.1.XX version.

Thank you for the bug report.
[18 Jul 2006 15:53] Peter Gulutzan
See also bug#6989, bug#8253.
[30 Sep 2008 14:28] Konstantin Osipov
Bug#8523 actually.