Hi everyone
Basically I'm trying to log data into an SQL server, I get the correct tag value and tag name, but with the time I'm not able to see it correctly in SQL
In SQL I have the column Time as data type: timestamp
and the data that logs is in hexadecimal, so is not what I want
I've actually use data type datetime2 as well in sql but then I get an error in Kepware (Error Data Logger Plug-in Unable to query recordset on Log Group 'loggroup'. Reason: Conversion failed when converting date and/or time from character string)
You can see it in the snapshots
does anyone know how can I actually submit the time in the SQL server? or like what datatype should be in Kepware and SQL? please help
