Use the search and browse 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.

Search Solutions 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