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.

Time Field Extractor

Extracts the selected time fields from a date/time column and appends the values as integer columns. Valid fields are hour, minute, second and millisecond. If the values are not set in the date/time column a missing value is added in the result table.

Dialog Options

Column containing time
Select the input column containing time.
Hour
Check if the hour of day should be extracted and appended as an integer column. The name for this column can be specified.
Minute
Check if the minute should be extracted and appended as an integer column. The name for this column can be specified.
Second
Check if the second should be extracted and appended as an integer column. The name for this column can be specified.
Millisecond
Check if the millisecond should be extracted and appended as an integer column. The name for this column can be specified.

Ports

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