DB Update on MS SQL Server does not always recognise local datetime column in WHERE part (5.4.4 o...

I’m using DB Update en DB Input nodes to maintain tables. These tables have begin and end columns (both datetime) to keep track what’s applicable when.

I’m updating the enddate when the validity of a record ends using the DB Update node. In the WHERE part I specify the primary key of the table in combination with the begindate as “include” and these columns are specified as “exclude” on the SET part.

This works fine when the begindate has time 00:00, but when it is a real time, it simply refuses to update the records. Below you see the (part of) the output of the DB Update, together with the added status (and error - but these are all empty).

Every update fails if the time is other than 00:00.

I’m using KNIME 5.4.4 on Windows11 and our database is MS SQL Server 19. The output type mapping is default, i.e.

Does anyone know a work-around how to get these updates working again?