[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?
OpenJDK Runtime Environment (build 1.8.0_71-b15)
MySQL Server version: 10.0.21-MariaDB MariaDB Server
Linux (Fedora 23)
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:
over 7 years ago
[This reply is migrated from our old forums.]
Re: datetime(3) not exported using table export
Thanks for reporting this. We will have a look and try to fix it.