Convert datetime to string with JDBC SQL Driver

KNIME Analytics Platform
1

Hi.
We tried to use the windows authentication with our SQL server. Due to the new authentication we had to change the SQL driver from jTDS to JDBC. So far so good, windows authentication works like expected.
But with the new driver, our datetime columns are now coming as date time (Local Date Time) and not as string with the jTDS driver.
Is there a way to map the datetime to string within the connector? We have about 100 query reader where we have to change mapping.

Thank you.

Regards
Martin

2

Use Microsoft JDBC. jTDS has limitations on date type.