While importing the data having DateTime/time column, the milliseconds values are not visible inside Spotfire Analyst
Article ID: KB0075593
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All versions |
Description
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
Example: 10/16/2009 3:25:55:754 PM => 10/16/2009 3:25:55 PM
Issue/Introduction
While importing the data having DateTime/time column, the milliseconds values are not visible inside Spotfire Analyst
Environment
All Supported OS
Resolution
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
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
Feedback
Yes
No
Powered by
