使用搜索功能查看 Kepware 的信息库,其中包含 500 多篇知识库文章。缩小搜索结果范围,或在下面的搜索字段中输入您的查询。

或者,如果您无法找到解决方案,我们还有另一个资源:我们的 PTC eSupport Portal。 如果系统提示您登录 eSupport Portal,您可以使用“我的 Kepware”凭据。需要一个“我的 Kepware”帐户吗?在此处创建

搜索解决方案结果:
View All Solutions

Kepware Knowledge Base: Solution


The Difference between TimeStamp and DataTime in MS SQL


Last Update: 2018/11/12

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