While importing the data having DateTime/time column, the milliseconds values are not visible inside Spotfire Analyst

While importing the data having DateTime/time column, the milliseconds values are not visible inside Spotfire Analyst

While importing the data having DateTime/time column from Connector or Information link connection, the milliseconds part values are not visible inside Spotfire Analyst.By default, Spotfire neglects the milliseconds value present inside the DateTime column

Example: 10/16/2009 3:25:55:754 PM => 10/16/2009 3:25:55 PM To resolve it, custom formatting options present inside the column properties can be used.

Example: M/d/yyyy h:mm:ss:fff




Note: 1) 'fff' is used to return the milliseconds part.
          2) TIBCO Spotfire can only show 3 digit value in the decimal part