I already read this topic (Long variable not shown in "DB Query Reader" but String variable is shown) and hope that since then something has changed (I am using Knime 4.5.2 and cannot change version cause compatibility with the Server).
Long integer values are not recognize / list in DB nodes executing SQL code (db SQL executor in my case). I cannot convert the longinteger (a ‘yyyymmddhhmmss’) as the the number would be shattered (string to int = ?; long to int = different number)
Unfortunately, I really need all the 12 digits to perform the operation in the DB node.
Is there a solution in Knime ?