Display millies in table viewer

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
fox802
Posts: 2
Joined: Tue 22 Apr 2014 14:11

Display millies in table viewer

Post by fox802 » Tue 22 Apr 2014 14:24

Hello,

I saw that an improvement of version 6.1 is
Microseconds support for TIME, DATETIME and TIMESTAMP data types
•Data Editor
•Data Export/Import wizards
•Data Comparison tool
I have downloaded version 6.1.166 but no millies visible in my timestamp columns...

The sql editor finds errors when I display the table script at every TIMESTAMP(6)...

Did I miss some configuration ?

Thanks per advance.

alexa

Re: Display millies in table viewer

Post by alexa » Tue 22 Apr 2014 14:43

Please perform the following:

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'.

fox802
Posts: 2
Joined: Tue 22 Apr 2014 14:11

Re: Display millies in table viewer

Post by fox802 » Wed 23 Apr 2014 07:40

Thanks alexa ! Exactly what I was looking for !

alexa

Re: Display millies in table viewer

Post by alexa » Wed 23 Apr 2014 11:17

Please let us know if any questions arise.

Post Reply