keep the fractional part of TIME type from MySQL when importing via connector

One of our customer had the issue that the fractional part of TIME type from MySQL is lost when importing via connector, e.g. value in DB 01:02:03.45 is imported as 01:02:03 where fractional part .45 is lost.

We have been told that this is by design a limitation due to MySQL ODBC driver.

We also confirmed other tools using MySQL ODBC driver also have this problem.

The feasible workaround is to using custom query ( select time_format(t1,'%H:%i:%s.%f') as test_time from dms.test_time ) to cast TIME to STRING and import it into Spotfire, then using calculated column ( Time([test_time]) ) to cast it back to Time type.

Our customer still expect this to be supported natively by Spotfire functionality.