Article - CS333296
How Can I View the Date/Time's Milliseconds Logged to a SQL Table and Displayed in Excel?
Modified: 02-Nov-2020
Applies To
- Kepware Server (formerly KEPServerEX) 5.19.467.0 to 6.8
- ThingWorx Kepware Server (legacy) 8.0 to 8.4
Description
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 .
This is a printer-friendly version of Article 333296 and may be out of date. For the latest version click CS333296