Extracting month, day and year from a Date variable

KNIME Analytics Platform
1

Does KNIME have a node to automatically extract month, day, year, etc from a Date/Time variable?

2

I use for this purposes Cell Splitter. May be there is another best way, but this works well for me.
Best regards, Max

1 Like
3

Hi vivek, hi max,

using the cell splitter is more a workaround as we already have a quite nice DateandTime variable in KNIME. You can find nodes for this variable time in the section Time Series.

In those you can at first use a StringtoDateTime node to parse your string containing the date/time.

Afterwards use the Date Field Extractor to extract month, day, year, etc. There is also a Time Field Extractor for hours, minutes, and so on.

Best regards, Iris

2 Likes
4

Thanks Iris & Max!