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


The Difference between TimeStamp and DataTime in MS SQL

Last Update: 11/12/2018
Print

MS-SQL internally interprets TIMESTAMP as binary used to process image information. It has nothing to do with OPC timestamps, dates, or time information. SQL_DATE or SQL_DATETIME should always be used to log OPC timestamp information.

Note 1: DataLogger can generate database tables. The DataLogger configuration suggests a set of column names and SQL data types that are compatible with the database being connected. Users are free to override these settings.

Note 2: The DataLogger runtime will detect requests to create SQL_TIMESTAMP columns on MS-SQL. It will then post an Event Log warning and override the column type, substituting SQL_DATETIME.

Related Products
DataLogger, KEPServerEX

© 2019 PTC Inc. All Rights Reserved.