Phpmyadmin Mysql Timestamp Shows Trailing Zeroes

Does anyone know why in phpMyAdmin/MySQL displaying Time Stamps changed from: 2012-10-20 08:43:28 to 2012-10-20 08:43:28.000000 with trailing zeroes. This seems to have start

Solution 1:

phpMyAdmin began displaying the fractional part of timestamps as of 4.1.0. If you'd like to display your timestamps without the fractional part, you can adapt this query:

SELECT DATE_FORMAT(`date`, '%Y-%m-%d %H:%i:%s') FROM your_table;

The result would look like this:

MariaDB [my_database]>SELECT DATE_FORMAT(`date`, '%Y-%m-%d %H:%i:%s') `date` 
    FROM your_table LIMIT 1;
+---------------------+|date|+---------------------+|2014-01-2217:54:11|+---------------------+1rowinset (0.00 sec)

MariaDB [my_database]>