How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

datetime(3) not exported using table export

[This topic is migrated from our old forums. The original author name has been removed]

When exporting MySQL tables using the GUI, columns defined as datetime(3) default to datetime. This means that milliseconds are lost and any code expecting milliseconds breaks. Did I export the tables incorrectly? Is defaulting to datetime a 'feature'? Is this something that is propagated from the underlying MySQL commands? System: DbVisulaizer 9.2.14 OpenJDK Runtime Environment (build 1.8.0_71-b15) MySQL Server version: 10.0.21-MariaDB MariaDB Server Linux (Fedora 23)
2 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: datetime(3) not exported using table export
Hi, Thanks for reporting this. We will have a look and try to fix it. Best Regards Hans
[This reply is migrated from our old forums.]

Re: datetime(3) not exported using table export
Hi, This is now fixed in DbVisualizer 9.2.15. Easiest is that you open Help->Check for Update in DbVisualizer to perform the upgrade. An alternative is that you download from our web site: http://www.dbvis.com/download/ Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1297 topics