Support for fractional datetime
since Mysql 5.6.4 (2011), there is a support for fractional datetime and timestamp.
cf. http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html
select now(6) should return 2015-07-16 23:48:52.720993 (like with phpmyadmin) and not 16/07/2015 23:46:52
or better , it should return the localized version 16/07/2015 23:46:52.720993
3
votes
Philippe SOHM
shared this idea
This can be setup as follows:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Data Editor → Formatting’ branch.
3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
5. Click ‘OK’.