There is a new KNIME forum. You can still browse and read content from our old forum but if you want to create new posts or join ongoing discussions, please visit our new KNIME forum: https://forum.knime.com

Convert epoch timestamp (unix) to classic date

Member for

5 years 6 months marketingthema

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

 

Comments
Sat, 03/07/2015 - 03:13

Member for

10 years 4 months

Iris

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

Sun, 03/08/2015 - 12:38

Member for

5 years 6 months

marketingthema

Thank you Iris,

Your strategy works :) i used seconds instead of milliseconds

Yours,

Thu, 09/21/2017 - 06:54

Member for

3 years

acudworth3

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