[SOLVED] DATETIME does not keep fractional seconds (5.6.11)

[P THE AWESOME]

No matter how I query the MySQL server (phpMyAdmin, NodeJS, or the Workbench) it rounds accordingly and then replaces my fractional seconds with zeros or just omits them. I am using MySQL Community Server 5.6.11 (which is greater than 5.6.4 when fractional seconds support was added).

Some more info about my server:

- Server version: 5.6.11-log - MySQL Community Server (GPL)
- Protocol version: 10
- Server charset: UTF-8 Unicode (utf8)
- Windows 8 Pro x86
- MySQL Workbench 6.0.8.11354 build 883 (Community)



NOTE: When viewing the table in phpMyAdmin, it shows all zeros for the fractional seconds. In the MySQL Workbench, it just omits them and only shows up to the second.

Thanks!



Edited 1 time(s). Last edit at 12/29/2013 02:42PM by P THE AWESOME.