Use the search feature to view Kepware's repository of more than 500 Knowledge Base articles. Narrow your results or type your query into the search field below.

Alternatively, if you are unable to find a solution, we have an additional resource - our PTC eSupport Portal . If you are prompted to log into the eSupport Portal, you can use your My Kepware credentials. Need a My Kepware account? Create one here .

Search Solution Results By:
View All Solutions

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.

Related Products
DataLogger, ODBC Client