To store timestamp(tag value) into a column which results in below error as the datatype of tag differs with column datatype. Is there any possibility of datatype conversion such that we can record its value into the database

Ignition
1

caused by Exception: Error executing system.db.runPrepUpdate(INSERT INTO love (timeisnow) VALUES (?), [[Thu Dec 12 09:10:01 IST 2019, Good, Thu Dec 12 11:17:23 IST 2019 (1576129643120)]], , , false, false)
caused by GatewayException: SQL error for “INSERT INTO love (timeisnow) VALUES (?)”: The conversion from UNKNOWN to UNKNOWN is unsupported.
caused by SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.

2

It looks like you are passing a complex type (a qualified value) where a simple value is needed. Adding .value to that QV is probably what you need. I can’t be more specific since you didn’t post your code.