# Update Named Query MSSQL Time Field

**URL:** <https://forum.inductiveautomation.com/t/update-named-query-mssql-time-field/34703>\
**Category:** Ignition\
**Created:** [May 13, 2020, 3:16pm UTC](https://forum.inductiveautomation.com/t/update-named-query-mssql-time-field/34703 "2020-05-13T15:16:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jalitten](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jalitten](https://forum.inductiveautomation.com/u/jalitten)\
**Post date:** [May 13, 2020, 3:16pm UTC](https://forum.inductiveautomation.com/t/update-named-query-mssql-time-field/34703/1 "2020-05-13T15:16:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jalitten](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jalitten](https://forum.inductiveautomation.com/u/jalitten)\
**Post date:** [May 14, 2020, 12:22pm UTC](https://forum.inductiveautomation.com/t/update-named-query-mssql-time-field/34703/2 "2020-05-14T12:22:22Z")

</div>

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.