Transformation of a Big Int to String

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?




Use the string manipulation node with the below code:


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


Thanks a lot , it works.