Hi all,
I am interested in the feature request #1397 [1], which requests that
phpMyAdmin support fractional seconds in time, datetime and timestamp data
types.
After bit of research I found that these data types support trailing
fractional seconds up to microseconds (6 digits). For example, the syntax
for datetime including fractional seconds would be '2013-04-23
11:21:07.145236'. This syntax is supported from version 5.0 [2], however
the fractional seconds were discarded when storing. From version 5.6.4
onwards these fractional seconds are stored and hence this feature request
is important.
I have looked into the code to implement this feature request and the major
problem faced is the incompatibility of JavaScript timepicker used [4],
which only supports up to milliseconds (3 digits). I have been improving
this JS file to support microseconds, however it is a somewhat big change.
I'd like to know whether I should simply alter the external JS file in
phpMyAdmin code or I should send a pull request to the timepicker project,
so it will be a part of the timepicker project as well. However, with the
second option it might take some time till they (hopefully) accept the
patch and do a release containing it.
Your thoughts on this would be highly appreciated.
[1]
https://sourceforge.net/p/phpmyadmin/feature-requests/1397/
[2]
https://dev.mysql.com/doc/refman/5.0/en/datetime.html
[3]
https://dev.mysql.com/doc/refman/5.6/en/datetime.html
[4]
http://trentrichardson.com/examples/timepicker/
--
Regards
Kasun Chathuranga