[Phpmyadmin-devel] Feature request #1397 - Include fractional seconds in timestamp

[Kasun Chathuranga]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20130423/c2f38b9b/attachment.html>