KNIME 4.1.1 Parameterized DB Query Date Mapping?

I use SQL-Server on script date time is converted to date type. Node output is a string type.
What needs to be done to have correct output as Local Date? I used default settings.

Do you use the new DB framework? There you can define input and output type mappings. If you are using date&time datatype in KNIME, by default it will be treated as dateTime in the database (if supported).

I use the new DB framework and date type from SQL Server DB converts to string by default. Could you reproduce my scenario?

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.