Extracts specific components from Date, Time, Date&time (Local), or Date&time (Zoned) columns. Appends the extracted values as integer or string columns, depending on the component.
Useful for extracting years, months, days, or time components for analysis, filtering, or visualization.
Options
Popular Predecessors
String to Date&Time16 %- GroupBy5 %
Create Date&Time Range5 %Row Filter (deprecated)5 %Date&Time Shift4 %- Excel Reader4 %
- Joiner4 %
- Date&Time Part Extractor3 %
- Column Filter3 %
- Column Expressions (legacy)3 %
- Rule-based Row Filter3 %
- Math Formula2 %
- Concatenate2 %
- Date&Time-based Row Filter2 %
- Rule Engine2 %
- String Manipulation2 %
- Duplicate Row Filter2 %
- Legacy Date&Time to Date&Time2 %
Column Rename1 %Modify Time1 %- String to Number1 %
- Sorter1 %
Date&Time Difference1 %- CSV Reader1 %
- Missing Value1 %
Modify Date< 1 %Date&Time to String< 1 %- DB Query Reader< 1 %
- Loop End< 1 %
- DB Reader< 1 %
- Column Resorter< 1 %
- Nominal Value Row Filter< 1 %
- String to Date/Time (legacy)< 1 %
Row Splitter (deprecated)< 1 %- Table Creator< 1 %
- Rule-based Row Splitter< 1 %
- Date&Time to legacy Date&Time< 1 %
- Constant Value Column< 1 %
- Column Renamer< 1 %
- Cell Splitter< 1 %
- Reference Row Filter< 1 %
- Python Source (legacy)< 1 %
- Value Counter< 1 %
- Moving Average< 1 %
Modify Time Zone< 1 %- Path to String< 1 %
- Reference Row Splitter< 1 %
- R Snippet< 1 %
- Variable to Table Row< 1 %
- Number to String< 1 %
- Parquet Reader< 1 %
- Pivot< 1 %
- Table Partitioner< 1 %
- Column Auto Type Cast< 1 %
- Cross Joiner< 1 %
- Rank< 1 %
- Date&Time Configuration< 1 %
- Column Combiner< 1 %
- Column Merger< 1 %
- RowID< 1 %
- String Manipulation (Multi Column)< 1 %
- Date&Time Input (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Line Plot (Plotly)< 1 %
- Row Aggregator< 1 %
- Column Selection Configuration< 1 %
- Counter Generation< 1 %
- Numeric Row Splitter< 1 %
- File Reader< 1 %
- Random Forest Predictor (Regression)< 1 %
Cell Replacer< 1 %- Domain Calculator< 1 %
- Number to String (PMML)< 1 %
- Top k Row Filter< 1 %
- Excel Writer< 1 %
- List Files/Folders< 1 %
- Value Filter (legacy)< 1 %
- Generic Loop Start< 1 %
- Numeric Scorer< 1 %
- Table Row to Variable< 1 %
- Table Reader< 1 %
- Group Loop Start< 1 %
- Statistics< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Date&Time Widget< 1 %
String to Duration< 1 %- Mask Date/Time (legacy)< 1 %
- CASE Switch Start< 1 %
- Empty Table Switch< 1 %
- Duplicate Filter< 1 %
- Variable to Table Column< 1 %
- File Reader (Complex Format)< 1 %
- Variable Creator< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
- Recursive Loop End< 1 %
- Regression Predictor< 1 %
- Random Forest Learner (Regression)< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Category to Number< 1 %
- Column Aggregator< 1 %
- Column Appender< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Name Replacer< 1 %
- One to Many< 1 %
- Linear Correlation< 1 %
- Double to Integer< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- Number Rounder< 1 %
- Row Sampler< 1 %
Column Splitter< 1 %- String Replacer< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- Color Manager< 1 %
- DB Connection Closer< 1 %
- Parameterized DB Query Reader< 1 %
- DB Writer< 1 %
- Math Formula (Multi Column)< 1 %
- Files/Folders Meta Info< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Filter (legacy)< 1 %
- Python Script (legacy)< 1 %
UNIX Timestamp to Date&Time< 1 %Extract Duration Fields< 1 %- Date Field Extractor (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Date Extractor< 1 %
- Lag Column< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Counting Loop Start< 1 %
- Extract Table Spec< 1 %
- Java Edit Variable (simple)< 1 %
- Chunk Loop Start< 1 %
- Moving Aggregator< 1 %
- Reference Column Filter< 1 %
- Document Data Extractor< 1 %
- Constant Value Column Filter< 1 %
Database Reader< 1 %- Value Lookup< 1 %
String Replace (Dictionary)< 1 %- Single Selection Configuration< 1 %
- Filter Apply< 1 %
- Row Splitter (Labs)< 1 %
- End IF< 1 %
- Interval Loop Start< 1 %
- Ungroup< 1 %
- Math Formula (Variable)< 1 %
- JSON Path< 1 %
- Time Difference (legacy)< 1 %
- Java Edit Variable< 1 %
Generic Loop Start< 1 %- Missing Value (Apply)< 1 %
- Linear Discriminant Analysis< 1 %
- IF Switch< 1 %
- Conditional Label Assigner< 1 %
- Random Number Assigner< 1 %
- Random Label Assigner< 1 %
- Java Snippet (simple)< 1 %
- Stanford Lemmatizer< 1 %
- String Configuration< 1 %
- XPath< 1 %
Flow Variable IF Switch< 1 %- Inject Variables (Data)< 1 %
Recursive Loop End< 1 %- Linear Regression Learner< 1 %
- Column Name Extractor< 1 %
- Reference Column Splitter< 1 %
- String to Number (PMML)< 1 %
- Cache< 1 %
- Conditional Box Plot (legacy)< 1 %
- Random Item Inserter< 1 %
- Unique Term Extractor< 1 %
- JSON to Table< 1 %
- GET Request< 1 %
SAP Reader (Theobald Software)< 1 %Duration to Number< 1 %- Time Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Twitter Timeline (legacy)< 1 %
Views
- This node has no views
Workflows
(Optional)_Linear_RegressionKNIME Hub- [ON] PEX ROTINAS 2024KNIME Hub
- 00 Send Reporting_vMediumKNIME Hub
- 01 - Email Database Data PreparationKNIME Hub
- 01 Data and Time and DatabasesKNIME Hub
- Show all 1775 workflows
Links
- How to group date by dayby qqilihq on 2021-11-01forum.knime.com/p/138399
- Grouping date by month errorby ipazin on 2022-11-08forum.knime.com/p/174494
- Nodo fecha de cargaby gonhaddock on 2022-05-11forum.knime.com/p/156601
- Day of the week based on dateby HansS on 2023-09-27forum.knime.com/p/236237
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.