how to convert data type of decimal into datetime .

@lakshmi_narayanan_t 

May i know the date time format you are looking for.

@lakshmi_narayanan_t regardless of the date format you wish it to transform the value to you probably need to first change the value from a data type “DECIMAL” to data type “STRING” before you can then translate it to data type “DATETIME”. This is because the format of the input value is the format of the output value, as documented here. This also means that you will need to transform the values from the decimal format to a recognized data format, first. You can achieve this with the Expression Evaluator stage, perhaps with something like this (where “/date” is the name of the column your source datetime field is named/numbered):

${time:extractDateFromString(record:value("/date"),"MMM dd yyyy hh:mm:ss")}