DB Query Reader DATE Input Type Mapping Incorrect

[jnicolich]

Date_Input.knwf (82.4 KB)

It appears that the DB Query Reader Input Type Mapping is not converting SQL Server 2016 “DATE” types into the default KNIME “Local Date”. Instead, the DB Query Reader returns a “String” type. The behavior for DateTime works as expected.
I am using KNIME Analytics Platform 5.1.2

[izaychik63]

It is a restriction of default JDBC. Use the Microsoft JDBC for correct Date mapping.

[jnicolich]

Thank you, that worked. Now I will need to research how to make the Microsoft JDBC driver the default.