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 While Logging Data to MySQL?

Last Update: 11/7/2018

MySQL versions preceding 5.6.4 do not support the storing of time-formatted data with a millisecond resolution event despite having a supported display format. This is a known issue. MySQL version 5.6.4 and after allow Date/Time data with millisecond resolution to be stored and displayed. For MySQL versions after V5.6.4, the format is %H:%i:%S.%f.

Related Products
DataLogger, ODBC Client