Update Named Query MSSQL Time Field

I keep getting the error message “Implicit conversion from data type datetime to bit is not allowed” when trying to run a update named query with system.db.runNamedQuery(). When I test the named query it works with no error, I have checked the data and its correct.

I found out the issue was some type of bug in 7.9.7, I had to delete and then recreate the time parameters in the named query.

1 Like