I’m trying to use the qualified value from a system.tag.read with a MSSQL stored procedure that I’m passing the “.timestamp” value to. I keep getting the error “The conversion from UNKNOWN to DATE is unsupported.” Playing around with script editor, and running this code:
tagVal = system.tag.read("SP_Test_Tag")
[1, Good, Wed May 04 22:01:30 CDT 2016]
Wed May 04 22:01:30 CDT 2016
First, will this not give me the millisecond timestamp and secondly, how the heck do I convert this into a datetime that I can pass to the stored procedure?