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

Marc Delisle marc at infomarc.info
Tue Apr 23 14:21:17 CEST 2013

Le 2013-04-22 23:06, Kasun Chathuranga a écrit :
> 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.

I think it's best to send them a pull request, asking them about their 
release plans. Forking their library in phpMyAdmin is problematic for 

Marc Delisle

More information about the Developers mailing list