Convert epoch timestamp (unix) to classic date

Hi everybody,

I have huge files with columns that are using epoch style for timestamp i need to convert them to classic dates, i searched all the nodes within knime but with no success ! is there a way to use a java snipet for this and what will be the transformation to use please ?

 

Thank you for your help

 

1 Like

It is the Date/Time Shift node you are looking for :-)

 

You can configure it to use a shift value from column (this is your timestamp) the granulartiy would be miliseconds, I suppose. Than choose a fixed date in the Date reference (e.g. the 1.1.1970)

 

Best, Iris

Thank you Iris,

Your strategy works :) i used seconds instead of milliseconds

Yours,

1 Like

Hey I am dealing with the same problem, but my epoch time is a digit type. How would you convert to date first so that you can use the date shift node?

 

Appreciate it.

Thanks

Andrew

There are two date time shift nodes, what Iris is referring to is Legacy. HTH

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.