-
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!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|