SQL Server Node : Convert int to Double

KNIME Analytics Platform
1

Hi, Everyone.

        I have the trouble of query statement convert int column to Double in DB node connecting with SQL Server Data.
        Please, someone, help me with how to write this query?

Thank you very much

2

Hi,
I think in SQL Server you have to use float for floating point numbers. So just do CAST(your column as float).
Kind regards
Alexander

2 Likes
3

Thank you , I think so.

4

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