The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

Date Field Extractor

Extracts the selected date fields from a date/time column and appends the values as integer columns. Available fields are year, quarter, month, day, day of week. If these values are not set in the date/time cell a missing value is added in the result table.

Dialog Options

Column containing dates
Select the input column containing the dates.
Year
Check if the year should be extracted and appended as an integer column. The name for this column can be specified.
Quarter
Check if the quarter as a number in [1,4] should be extracted and appended as an integer column. The name for this column can be specified.
Month
Check if the month should be extracted and appended as an extra column. Select whether the (English) name of the month should be appended to the output table (Text) or the number of the month (Number) in [1, 12]. The name for this column can be specified.
Day
Check if the day of month should be extracted and appended as an integer column. The name for this column can be specified.
Day of Week
Check if the day of week should be extracted and appended as an extra column. Select whether the (English) name of the day (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday) should be appended to the output table (Text) or the number of the day in the week (Number) in [1, 7] starting with Sunday. The name of this column can be specified.
Day of Year
Check if the day of year should be extracted and appended as an integer column. The name of this column can be specified.

Ports

Input Ports
0 Table containing date/time cells.
Output Ports
0 Input table with extracted date fields appended
This node is contained in KNIME Time Series Nodes provided by KNIME GmbH, Konstanz, Germany.