This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
Extracts the selected fields from a Local Date, Local Time, Local Date Time or Zoned Date Time column and appends their values as corresponding integer or string columns.
Options
Column Selection
Date Fields
Time Fields
Time Zone Fields
Localization
Popular Successors
- GroupBy3 %
String To Number3 %- k-Means2 %
- Partitioning2 %
Column Rename2 %- Extract Time Window (legacy)2 %
Concatenate (Optional in)2 %- Nominal Value Row Filter1 %
Joiner1 %- Number Formatter1 %
Row Filter (deprecated)1 %- Column Rename (Regex)1 %
- Rule-based Row Filter1 %
Gradient Boosted Trees Learner (Regression)1 %Cell Replacer< 1 %- Bar Chart (JavaScript)< 1 %
- Rule Engine< 1 %
Table Writer< 1 %- Lag Column< 1 %
- Math Formula< 1 %
- Date&Time Difference< 1 %
- Column Resorter< 1 %
Python Script (1⇒1)< 1 %- Modify Time< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
- Category to Number< 1 %
- Row Sampling< 1 %
- Histogram (legacy)< 1 %
Table Row to Variable< 1 %Variable Condition Loop End< 1 %- Column Filter< 1 %
- String Manipulation< 1 %
- ARIMA Learner< 1 %
- Polynomial Regression Learner< 1 %
- Column Comparator< 1 %
- Cross Joiner< 1 %
- Color Manager< 1 %
Excel Writer (XLS)< 1 %- Value Filter (legacy)< 1 %
- Java Snippet< 1 %
- Linear Regression Learner< 1 %
- Linear Correlation< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Cache< 1 %
DB Loader< 1 %- Similarity Search< 1 %
- Column Expressions (legacy)< 1 %
- Modify Date< 1 %
- Date Field Extractor (legacy)< 1 %
CSV Writer< 1 %Loop End< 1 %Cell Splitter< 1 %- Column Combiner< 1 %
- Duplicate Row Filter< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- Rank< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- One-way ANOVA< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Cell Splitter< 1 %
- Number to String< 1 %
- Column Appender< 1 %
- Missing Value (Apply)< 1 %
- Number Rounder< 1 %
- Numeric Outliers< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Filter< 1 %
- Scatter Plot (JavaScript)< 1 %
- Date&Time to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Moving Aggregator< 1 %
- One to Many< 1 %
- Pivot< 1 %
- Rule-based Row Splitter< 1 %
DB Table Creator< 1 %- Python Script (legacy)< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %- Group Loop Start< 1 %
- Naive Bayes Learner< 1 %
- Simple Regression Tree Learner< 1 %
- Numeric Binner< 1 %
- Column Auto Type Cast< 1 %
- Column Merger< 1 %
Row Splitter (deprecated)< 1 %- Missing Value< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- Value Counter< 1 %
- Interactive Histogram (legacy)< 1 %
- Excel Writer< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Date&Time-based Row Filter< 1 %
- Modify Time Zone< 1 %
- Moving Average< 1 %
- Table Row to Variable< 1 %
- CSV Writer< 1 %
- Java Edit Variable< 1 %
- X-Partitioner< 1 %
Gradient Boosted Trees Learner< 1 %- Concatenate< 1 %
- String to Number< 1 %
- Column Aggregator< 1 %
- Constant Value Column< 1 %
- Double to Integer< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Filter< 1 %
- Joiner< 1 %
Number To String (PMML)< 1 %- RowID< 1 %
- Sorter< 1 %
Rank Correlation< 1 %- Statistics< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Conditional Box Plot (legacy)< 1 %
- Time Series Generator< 1 %
- Distance Matrix Calculate< 1 %
- Table to H2O< 1 %
- Math Formula (Multi Column)< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Java Snippet Row Splitter< 1 %
Tableau Writer (TDE)< 1 %- Strings to Document< 1 %
- Google Sheets Updater< 1 %
- Date&Time to legacy Date&Time< 1 %
- String to Date&Time< 1 %
- Date&Time Shift< 1 %
- Window Loop Start< 1 %
- String to Date/Time (legacy)< 1 %
IF Switch (Flow Variable Value)< 1 %- Hierarchical Clustering< 1 %
- Logistic Regression Learner< 1 %
- Regression Predictor< 1 %
- Case Converter< 1 %
- Column to Grid< 1 %
- Reference Row Splitter< 1 %
- Column Splitter< 1 %
- Rank Correlation< 1 %
- Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- DB Update< 1 %
- DB Writer< 1 %
- Random Matcher< 1 %
- Line Plot (Plotly)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Java Snippet (simple)< 1 %
- Preset Date/Time (legacy)< 1 %
- Date Extractor< 1 %
- ARIMA Visualization< 1 %
- Split Collection Column< 1 %
- Extract Variables (Data)< 1 %
- Table Column to Variable< 1 %
Database Writer< 1 %Loop End (2 ports)< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %- PNN Learner (DDA)< 1 %
Scorer< 1 %- Cell Splitter By Position< 1 %
Column Appender< 1 %- Column Name Extractor< 1 %
- Extract Missing Value Cause< 1 %
- Constant Value Column Filter< 1 %
- Ruleset Editor< 1 %
- Rule Engine (Dictionary)< 1 %
- End IF< 1 %
- Interactive Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
Color Appender< 1 %- DB Connection Closer< 1 %
- DB Insert< 1 %
- Gaussian Distributed Assigner< 1 %
- Violin Plot (Plotly)< 1 %
- Universe Marker< 1 %
- External Tool< 1 %
- Math Formula (Variable)< 1 %
- Google Sheets Appender< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Columns to JSON< 1 %
- R Snippet< 1 %
- Data to Report (BIRT)< 1 %
- Duration to Number< 1 %
- Time to String (legacy)< 1 %
- Open in R< 1 %
- Wait...< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Naive Bayes Learner< 1 %Regression Predictor< 1 %- PCA Apply< 1 %
- Random Forest Learner (Regression)< 1 %
- Filter Apply< 1 %
- Numeric Binner (PMML)< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- String Splitter (Regex)< 1 %
- String Replacer< 1 %
- Data Explorer< 1 %
- Independent groups t-test< 1 %
- Crosstab< 1 %
- Scatter Matrix (legacy)< 1 %
- One Row to Many< 1 %
- Box Plot (JavaScript)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Variable Expressions (legacy)< 1 %
- Line Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
TIBCO File Writer< 1 %- Number Filter< 1 %
- OpenNLP NE Tagger< 1 %
- Value Selection Configuration< 1 %
- Slider Input (legacy)< 1 %
- Nominal Row Filter Widget< 1 %
- Container Output (Table)< 1 %
- Python View (legacy)< 1 %
- R View (Table)< 1 %
- String to Duration< 1 %
- Extract Duration Fields< 1 %
- Time Difference (legacy)< 1 %
- Time Domain Features (TDF)< 1 %
- Total Count< 1 %
- Notched Boxplot (JFreechart)< 1 %
- CV< 1 %
- R Snippet< 1 %
- 2D/3D Scatterplot< 1 %
- ARIMA Predictor< 1 %
- Create Collection Column< 1 %
- Create Directory (legacy)< 1 %
- Strings to Binary Objects< 1 %
Variable to Table Column< 1 %- Variable to Table Column< 1 %
- Create File Name (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %- Variable to Table Row< 1 %
- Table to Image< 1 %
Database Delete< 1 %Database Looping< 1 %Parameterized Database Query< 1 %Database Table Creator< 1 %File Reader< 1 %Table Reader< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
Generic Loop Start< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %- Fuzzy c-Means< 1 %
- Decision Tree Learner< 1 %
- Decision Tree Predictor< 1 %
K Nearest Neighbor< 1 %- RProp MLP Learner< 1 %
PCA Compute< 1 %- Logistic Regression Predictor< 1 %
- Association Rule Learner< 1 %
- SVM Learner< 1 %
- PCA< 1 %
- Gradient Boosted Trees Learner< 1 %
Gradient Boosted Trees Predictor< 1 %- Gradient Boosted Trees Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Learner (Regression)< 1 %
Random Forest Learner< 1 %- Random Forest Learner< 1 %
- Random Forest Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Perl Scripting< 1 %
- Auto-Binner< 1 %
- Number to Category (Apply)< 1 %
Number To String< 1 %- Column Renamer (Dictionary)< 1 %
- Many to One< 1 %
Linear Correlation< 1 %- Correlation Filter< 1 %
- Table Validator< 1 %
- CAIM Binner< 1 %
- Domain Calculator< 1 %
- Reference Column Filter< 1 %
- One to Many (PMML)< 1 %
String To Number (PMML)< 1 %- Numeric Row Splitter< 1 %
- Shuffle< 1 %
- String Manipulation (Variable)< 1 %
String Replace (Dictionary)< 1 %- Target Shuffling< 1 %
- Top k Row Filter< 1 %
- Ungroup< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Cronbach Alpha< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Timer Info< 1 %
- Lift Chart (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- DB Query< 1 %
- Counter Generation< 1 %
- Random Number Assigner< 1 %
- k-Medoids< 1 %
- 2D Density Plot (Plotly)< 1 %
- Histogram (JavaScript)< 1 %
- Scatter Plot (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
Table to HTML< 1 %- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Bar Chart (JFreeChart)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Interval Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- LIBSVMLearner< 1 %
- OSM Map View< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %- Spark Line Appender< 1 %
- DF< 1 %
- Chi-Square Keyword Extractor< 1 %
- String Matcher< 1 %
- Case Converter< 1 %
- Dictionary Tagger< 1 %
- Wildcard Tagger< 1 %
- Document Vector Hashing< 1 %
- Document Viewer< 1 %
- String to Path< 1 %
- Column Filter Configuration< 1 %
- Nominal Row Filter Configuration< 1 %
- Integer Slider Configuration< 1 %
- Column Selection Configuration< 1 %
- Value Selection (legacy)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Heatmap (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Table to JSON< 1 %
- Don't Save End< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
Python Script (1⇒1)< 1 %- Table to R< 1 %
- Create Date&Time Range< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
XGBoost Tree Ensemble Learner (Regression)< 1 %- XGBoost Predictor (Regression)< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
01 Date and Time ManipulationKNIME Hub- 01 Date and Time ManipulationKNIME Hub
- 01 Date and Time ManipulationKNIME Hub
- 01 Date and Time ManipulationKNIME Hub
- 01 Date and Time ManipulationKNIME Hub
- Show all 401 workflows
Links
- Issue with Send to Power BI Node Datesby armingrudd on 2020-03-10forum.knime.com/p/83845
- Converting Dates during ETL proceduresby Andrew_Steel on 2019-10-03forum.knime.com/p/71618
- Date Mapping through Date intervalsby mlauber71 on 2019-10-07forum.knime.com/p/71828
- Drop down menu in a plotby armingrudd on 2020-06-28forum.knime.com/p/95440
- Loop until previous date is not weekends and holidaysby JanDuo on 2020-08-26forum.knime.com/p/100780
- Show all 12 links
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.