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
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)
Thank you Iris,
Your strategy works :) i used seconds instead of milliseconds
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?
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.