Transformation of a Big Int to String

KNIME Analytics Platform
1

Hi all

I am new to Knime and I try to retrieve data from a MySQL database where the date is stored as a Big Int and has the following format : YYYYMMDDHHMM; when I retieve the field through the Database connection reader , I get a Double Int and when I try to transform it as a String using the Number To String Node , I get something like : 2.0140301E11 instread of 201403010000.

Is there a parameter to set somewhere or is there another node doing the right job?

Regards

Loys

2

Hi,

Use the string manipulation node with the below code:

string(toLong($column1$))

where $column1$ is the name of the column you want to convert.

3

Hi

Thanks a lot , it works.