Database Query SQL Statement

KNIME Analytics Platform
#1

Hi @All,

I’ve got a column as double which includes a Date:
30

Now I have tried to use the Database Query Node in the first step to transform the column from double to int unfortunately without success.
I have tried it with several CAST and CONVERT statements but nothing worked.

Has anybody an idea how I can solve this problem?

Many thanks in regard!
Rüdiger W.

#2

It depends on what you want to do. Datetime field has date and time separated by coma, so it is double. If you do not need time portion convert Datetime to date first and then to the int.