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.
@Fra_S3k_knime would it be possible to tell us what you actually want to do? Load data into a database? Use Flow Variables in a SQL query? Mabye you could produce a
small workflow to show where things go wrong.
[EDIT: created an example to experiment with settings]