R node - Date read as Timestamp instead of DateTime format.

Hi,

I am using R source (workspace) node to extract Twitter data. However the "created" column in the output is showing value in timestamp (epoch format).

However on using the same R script outside KNIME, the data is available in desired DateTime format (dd/mm/yyyy hh:mm:ss)

Attached is the workflow. Please let me know where i am going wrong or suggest an alternative.

Regards,

Marvin

Hello Marvin,

I am no R user, sorry, but I have a workaround for your problem:

If you use a String Manipulation node on your epoch timestamp like this:

string("1970.01.01 00:00:")+$timestamp$

And then use a  String to Date/Time node with the format

yyyy.MM.dd HH:mm:ss

you will get your timestamp as a Date/Time column, which you can then use in the Analytics Platform or output in whatever format you like with the Time to String node.

Hope that helps!
Best,
Ferry