Kepware Knowledge Base: Solution
How Can I View the Date/Time's Milliseconds Logged to a SQL Table and Displayed in Excel?
Last Update: 11/7/2018
To view the milliseconds of a Date/Time field logged to a SQL table and displayed in Excel, users must set a custom format for the cells in the column containing the timestamp. The format for Date/Time with milliseconds displayed is m/d/yyyy h:mm.ss.000.
©
2021
PTC Inc. All Rights Reserved.