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
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
Issue/Introduction
While importing the data having DateTime/time column, the milliseconds values are not visible inside Spotfire Analyst
Feedback
Yes
No
Powered by
