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
Hi,
when discussing [0], a question arose. When phpMyAdmin thinks that there
are no rows, some tabs are greyed out. However they can still be clicked
, because by the time the page has been displayed, another process might
have written some rows to this table.
But clickable greyed out tabs is confusing for some users. Let's decide
about this (for 4.1):
1. no longer grey out
2. grey out but not clickable
3. status quo
[0] https://sourceforge.net/p/phpmyadmin/bugs/3904/
--
Marc Delisle
http://infomarc.info