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 Predecessors
Loop End3 %- Statistics2 %
Column Appender2 %Number To String2 %- Numeric Binner2 %
Create Date&Time Range2 %- DB Query Reader2 %
Constant Value Column2 %String to Date&Time2 %Cell Splitter1 %Variable to Table Row1 %Variable to Table Column1 %- Concatenate1 %
Excel Reader (XLS)1 %Table Row to Variable< 1 %Database Reader< 1 %- Double to Integer< 1 %
- Filter Apply< 1 %
- GroupBy< 1 %
- Unpivot< 1 %
- Cell Splitter By Position< 1 %
- Column Aggregator< 1 %
- String Manipulation (Multi Column)< 1 %
Python Script (1⇒1)< 1 %- CSV Reader< 1 %
CSV Reader< 1 %- Column Auto Type Cast< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Rule-based Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- R Snippet< 1 %
Excel Reader (XLS)< 1 %- Variable to Table Row< 1 %
DB Merge< 1 %- Row Sampler< 1 %
- String Replacer< 1 %
- Time Generator (legacy)< 1 %
- Duplicate Row Filter< 1 %
CASE Switch Data (Start)< 1 %- Lag Column< 1 %
- Column Resorter< 1 %
- Cross Joiner< 1 %
- RowID< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Preset Date/Time (legacy)< 1 %
- XPath< 1 %
- Number to String< 1 %
- Math Formula (Multi Column)< 1 %
- Time Difference (legacy)< 1 %
Table Row To Variable Loop Start< 1 %- Column Combiner< 1 %
- Pivot< 1 %
- String Manipulation< 1 %
- Date&Time Input (legacy)< 1 %
- Date&Time Configuration< 1 %
- Case Converter< 1 %
- Sorter< 1 %
- Rule Engine< 1 %
- Table Partitioner< 1 %
- Ungroup< 1 %
- Parameterized DB Query Reader< 1 %
- Column Expressions (legacy)< 1 %
String to Duration< 1 %- Moving Average< 1 %
File Reader< 1 %Table Reader< 1 %- Table Creator< 1 %
- Java Snippet< 1 %
- Column Merger< 1 %
- Domain Calculator< 1 %
- Column Filter< 1 %
Row Filter (deprecated)< 1 %Joiner< 1 %- Missing Value< 1 %
Column Rename< 1 %- Number Rounder< 1 %
- Math Formula< 1 %
Date&Time Difference< 1 %Date&Time to String< 1 %- Date&Time to legacy Date&Time< 1 %
UNIX Timestamp to Date&Time< 1 %Extract Date&Time Fields< 1 %- Date&Time-based Row Filter< 1 %
Date&Time Shift< 1 %Modify Date< 1 %Modify Time< 1 %- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
Variable to Table Row< 1 %Database Looping< 1 %Loop End (2 ports)< 1 %- Cell Splitter< 1 %
- Category to Number< 1 %
- String to Number< 1 %
- Joiner< 1 %
String To Number (PMML)< 1 %String Replace (Dictionary)< 1 %- Value Counter< 1 %
- Numeric Outliers< 1 %
Parquet Reader< 1 %- DB Reader< 1 %
- String Input (legacy)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Date Extractor< 1 %
- Table Manipulator< 1 %
- Excel Reader< 1 %
- Date&Time Part Extractor< 1 %
Variable to Table Column< 1 %Recursive Loop End (2 ports)< 1 %Auto-Binner< 1 %Column Splitter< 1 %- IF Switch< 1 %
Table Column to Variable< 1 %- Chunk Loop Start< 1 %
Cell Replacer< 1 %- Column Appender< 1 %
- Row Splitter (Labs)< 1 %
- Send to Tableau Server< 1 %
- JSON to Table< 1 %
- Empty Table Switch< 1 %
- Excel Writer< 1 %
- Catch Errors (Data Ports)< 1 %
- Constant Value Row Appender< 1 %
Auto-Binner (Apply)< 1 %- Rank< 1 %
- String Manipulation (Variable)< 1 %
Merge Variables< 1 %- Java IF (Table)< 1 %
- Run Garbage Collector< 1 %
- Numeric Scorer< 1 %
- Row Filter (Labs)< 1 %
- Normalizer< 1 %
- Rank Correlation< 1 %
- Data Generator< 1 %
- Spark to Table< 1 %
- Single Selection Configuration< 1 %
- Python Source (legacy)< 1 %
Duration to Number< 1 %- Table Reader< 1 %
Parquet Reader< 1 %- Extract Variables (Data)< 1 %
- Decision Tree Predictor< 1 %
String To Number< 1 %- Column Name Replacer< 1 %
- Counter Generation< 1 %
- Java Snippet (simple)< 1 %
- Date/Time Shift (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- URL to File Path (Variable)< 1 %
Recursive Loop Start< 1 %- PCA< 1 %
- Column Comparator< 1 %
- Column Renamer (Dictionary)< 1 %
Linear Correlation< 1 %- Reference Row Splitter< 1 %
CASE Switch Data (End)< 1 %- Parallel Chunk End< 1 %
- Parallel Chunk Start< 1 %
- DB Connection Closer< 1 %
- Time Series Generator< 1 %
- Strings to Document< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Date&Time Widget< 1 %
- Window Loop Start< 1 %
- Loop End (Column Append)< 1 %
- CASE Switch Start< 1 %
DB Insert< 1 %- Line Plot (Plotly)< 1 %
- Python Script (legacy)< 1 %
- ARIMA Predictor< 1 %
File Meta Info< 1 %- Breakpoint< 1 %
Database Connection Table Reader< 1 %Counting Loop Start< 1 %- Column List Loop Start< 1 %
Variable Condition Loop End< 1 %Generic Loop Start< 1 %- Group Loop Start< 1 %
Naive Bayes Predictor< 1 %- Linear Regression Learner< 1 %
Concatenate (Optional in)< 1 %- One to Many< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Filter< 1 %
- String Splitter (Regex)< 1 %
- Cache< 1 %
- Color Manager< 1 %
Extract Duration Fields< 1 %Modify Time Zone< 1 %Flow Variable IF Switch< 1 %Loop End (3 ports)< 1 %- Run Heavy Garbage Collector< 1 %
- Outlier Removal< 1 %
- Columns to Collection< 1 %
- Split Collection Column< 1 %
List Remote Files< 1 %- Try (Data Ports)< 1 %
- Active Branch Inverter< 1 %
Create File Name< 1 %Extract Context Properties< 1 %Simple File Reader< 1 %- Fixed Width File Reader< 1 %
List Files< 1 %- PNN Predictor< 1 %
- Cluster Assigner< 1 %
- Tree Ensemble Learner< 1 %
- Category to Number (Apply)< 1 %
- Column to Grid< 1 %
- Correlation Filter< 1 %
- Table Structure Creator< 1 %
- Extract Missing Value Cause< 1 %
- Constant Value Column Filter< 1 %
- Missing Value (Apply)< 1 %
- Table Transposer< 1 %
- Ruleset Editor< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
Rank Correlation< 1 %- Data Explorer< 1 %
- End IF< 1 %
- Extract Table Spec< 1 %
- Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- Histogram (legacy)< 1 %
- DB Joiner< 1 %
- Gaussian Distributed Assigner< 1 %
- Java Snippet Row Splitter< 1 %
- Replacer< 1 %
- Document Data Extractor< 1 %
- Google Sheets Reader< 1 %
- Nominal Row Filter Configuration< 1 %
- String Configuration< 1 %
- Value Filter (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- Double Input (legacy)< 1 %
- Column Filter Widget< 1 %
Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %- R to Table< 1 %
- GET Request< 1 %
Duration to String< 1 %- Extract Time Window (legacy)< 1 %
- Time to String (legacy)< 1 %
- Twitter Timeline (legacy)< 1 %
- Byte Converter< 1 %
- Web Log Reader< 1 %
- Remove Empty Rows< 1 %
Drag and Drop< 1 %- Wait...< 1 %
- Extract System Properties< 1 %
- File Reader< 1 %
Recursive Loop Start (2 ports)< 1 %- SMOTE< 1 %
- Reference Column Filter< 1 %
- Number to String (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Merge Variables< 1 %
- Box Plot (legacy)< 1 %
- Empty Table Creator< 1 %
- H2O Statistics< 1 %
Read Excel Sheet Names (XLS)< 1 %- Files/Folders Meta Info< 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 435 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.