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.
Options
Popular Successors
Joiner7 %- Scatter Plot (JFreeChart)6 %
- Time to String (legacy)4 %
- Moving Average3 %
Number To String2 %- R Snippet2 %
Date&Time to String2 %- Numeric Binner2 %
- Reference Row Filter2 %
- String Manipulation2 %
- Java Snippet (simple)2 %
- Number to String2 %
- Domain Calculator2 %
- GroupBy2 %
- Joiner2 %
- Sorter2 %
- Rule-based Row Filter2 %
- Rule Engine2 %
- Scatter Matrix (legacy)2 %
- Math Formula2 %
Extract Date&Time Fields2 %CSV Writer1 %- Column Resorter1 %
- RowID1 %
Table Writer< 1 %- Java Snippet< 1 %
- Group Loop Start< 1 %
Auto-Binner< 1 %- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- Column Aggregator< 1 %
- CAIM Binner< 1 %
- Filter Apply< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Date Field Extractor (legacy)< 1 %
- 2D/3D Scatterplot< 1 %
Loop End< 1 %Naive Bayes Predictor< 1 %- Column Merger< 1 %
- One to Many< 1 %
Constant Value Column< 1 %Row Splitter (deprecated)< 1 %- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Extract Table Spec< 1 %
- Histogram (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
Excel Writer (XLS)< 1 %Date&Time Shift< 1 %- Date/Time Shift (legacy)< 1 %
- Moving Aggregator< 1 %
- Range Splitter< 1 %
- ARIMA Learner< 1 %
- Columns to Collection< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Database Writer< 1 %- CSV Writer< 1 %
- Hierarchical Clustering< 1 %
k-Means (deprecated)< 1 %Gradient Boosted Trees Learner< 1 %- Random Forest Learner (Regression)< 1 %
- Concatenate< 1 %
Auto-Binner (Apply)< 1 %- Binner (Dictionary)< 1 %
Cell Replacer< 1 %Cell Splitter< 1 %- Category to Number< 1 %
String To Number< 1 %Column Appender< 1 %- Lag Column< 1 %
- Cross Joiner< 1 %
- Edit Numeric Domain< 1 %
- Double to Integer< 1 %
- Column Filter< 1 %
- Nominal Value Row Filter< 1 %
Row Filter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Normalizer< 1 %
- Table Partitioner< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Rank< 1 %
Column Rename< 1 %- Number Rounder< 1 %
- Table Transposer< 1 %
- Rule Engine (Dictionary)< 1 %
Rank Correlation< 1 %- Statistics< 1 %
- Cache< 1 %
- Interactive Histogram (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Color Manager< 1 %
- Column Expressions (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- HeatMap (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Spark Line Appender< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Dimension Cleaner< 1 %
Python Script (1⇒1)< 1 %Column Selection QuickForm (legacy)< 1 %Duration to Number< 1 %- Legacy Date&Time to Date&Time< 1 %
String to Date&Time< 1 %UNIX Timestamp to Date&Time< 1 %- Date&Time Part Extractor< 1 %
Modify Time< 1 %- Time Difference (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Latitude/Longitude to Coordinate< 1 %
- URL Normalizer< 1 %
Views
- This node has no views
Workflows
03_ETL_Energy_autocorr_statsKNIME Hub- 03_ETL_Energy_autocorr_statsKNIME Hub
- 03_ETL_Energy_autocorr_statsKNIME Hub
- 1-Prepare Data reduced resetKNIME Forum
- EDAKNIME Hub
- Show all 9 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.