DATETIME does not keep fractional seconds
No matter how I query the MySQL server (phpMyAdmin or NodeJS) it 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!