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

The Difference between TimeStamp and DataTime in MS SQL

Last Update: 11/12/2018

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