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:

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


Sat, 03/07/2015 - 03:13

Member for

10 years 4 months


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


Thank you Iris,

Your strategy works :) i used seconds instead of milliseconds


Thu, 09/21/2017 - 06:54

Member for

3 years


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.