datetime(3) not exported using table export : DbVis Software

a

anonymous

started a topic almost 9 years ago

[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)

Hans Bergsten

said almost 9 years ago

[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

Roger Bjärevall

said over 8 years ago

[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

How can we help you today?

datetime(3) not exported using table export

anonymous

Hans Bergsten

Roger Bjärevall