Page 1 of 1

Display millies in table viewer

Posted: Tue 22 Apr 2014 14:24
by fox802
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.

Re: Display millies in table viewer

Posted: Tue 22 Apr 2014 14:43
by alexa
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'.

Re: Display millies in table viewer

Posted: Wed 23 Apr 2014 07:40
by fox802
Thanks alexa ! Exactly what I was looking for !

Re: Display millies in table viewer

Posted: Wed 23 Apr 2014 11:17
by alexa
Please let us know if any questions arise.