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.
Modifies date&time columns in three different ways. The
node can append a date to local time columns (output type is local or
zoned date time column)
or
change the date in local or zoned date&time columns
or
remove the date from local or zoned date&time columns
(output type is local time).
This node is not used to add ("plus") or subtract ("minus") date. Use
the
Date&Time Shift
node for that.
Options
Column Selection
Replace/Append Selection
Date Selection
Popular Predecessors
String to Date&Time7 %Joiner3 %- Rule-based Row Filter2 %
- Date&Time to legacy Date&Time2 %
Number To String2 %Row Filter (deprecated)2 %- Column Auto Type Cast2 %
- GroupBy2 %
- Joiner2 %
Create Date&Time Range1 %Variable to Table Row1 %Concatenate (Optional in)1 %Column Rename1 %- Date&Time-based Row Filter1 %
Date&Time Shift1 %Date&Time Difference1 %Extract Date&Time Fields1 %- Time Generator (legacy)1 %
- CSV Reader1 %
File Reader1 %Cell Splitter1 %- Excel Reader1 %
Modify Time< 1 %- Python Source (legacy)< 1 %
- Date Extractor< 1 %
- Column Filter< 1 %
- Row Sampler< 1 %
Modify Date< 1 %Excel Reader (XLS)< 1 %Database Reader< 1 %- Concatenate< 1 %
Constant Value Column< 1 %- Missing Value< 1 %
Date&Time to String< 1 %UNIX Timestamp to Date&Time< 1 %File Meta Info< 1 %- Cross Joiner< 1 %
- Duplicate Row Filter< 1 %
- Reference Row Filter< 1 %
- Cell Splitter By Position< 1 %
- Python Script (legacy)< 1 %
- Table Creator< 1 %
- Java Snippet< 1 %
- Column Combiner< 1 %
Column Appender< 1 %- Column Resorter< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Sorter< 1 %
- String Manipulation< 1 %
- String Replacer< 1 %
- Rule Engine< 1 %
- Math Formula< 1 %
- Date&Time Input (legacy)< 1 %
- Legacy Date&Time to Date&Time< 1 %
Modify Time Zone< 1 %- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
Table Row to Variable< 1 %Loop End< 1 %- Cell Splitter< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Column Merger< 1 %
- Double to Integer< 1 %
Column Splitter< 1 %- Table Transposer< 1 %
- Rule-based Row Splitter< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- Column Expressions (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet (simple)< 1 %
- Date&Time Configuration< 1 %
- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- Loop End< 1 %
- Column Appender< 1 %
- Table Manipulator< 1 %
- String Manipulation (Multi Column)< 1 %
- Files/Folders Meta Info< 1 %
- Date&Time Part Extractor< 1 %
- XPath< 1 %
- Missing Value (Apply)< 1 %
- Table Column to Variable< 1 %
- Table Reader< 1 %
- Column Renamer< 1 %
- Date&Time Widget< 1 %
- Regex Extractor< 1 %
- Group Loop Start< 1 %
Table Row to Variable< 1 %- Column Aggregator< 1 %
- Lag Column< 1 %
- Pivot< 1 %
Excel Reader (XLS)< 1 %Variable to Table Row< 1 %- Spark to Table< 1 %
- Time to String (legacy)< 1 %
- Number to String (PMML)< 1 %
- Table Partitioner< 1 %
- String Input (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
Table Column to Variable< 1 %Cell Replacer< 1 %- Data Explorer< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
Container Input (Variable)< 1 %- InfluxDBConnector< 1 %
CSV Reader< 1 %Counting Loop Start< 1 %- Mask Date/Time (legacy)< 1 %
Auto-Binner< 1 %- Column Comparator< 1 %
- Value Counter< 1 %
Excel Writer (XLS)< 1 %- Google Sheets Reader< 1 %
- Extract Time Window (legacy)< 1 %
- Variable Creator< 1 %
- Domain Calculator< 1 %
Google Analytics Query (deprecated)< 1 %Database Connection Table Reader< 1 %Table Reader< 1 %String To Number< 1 %- RowID< 1 %
- Distance Matrix Calculate< 1 %
- RSS Feed Reader< 1 %
Click< 1 %- Number Formatter< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %Recursive Loop Start< 1 %- Binner (Dictionary)< 1 %
- Category to Number< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Number Rounder< 1 %
- String Manipulation (Variable)< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
CASE Switch Data (End)< 1 %CASE Switch Data (Start)< 1 %- Timer Info< 1 %
- Empty Table Creator< 1 %
- One Row to Many< 1 %
- Time Series Generator< 1 %
- Column Filter (legacy)< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
Date (String) Input (legacy)< 1 %- R to Table< 1 %
String to Duration< 1 %- Window Loop Start< 1 %
- Time Difference (legacy)< 1 %
- Moving Aggregator< 1 %
Download< 1 %- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
- Extract System Properties< 1 %
- File Reader (Complex Format)< 1 %
- SVM Predictor< 1 %
- Constant Value Row Appender< 1 %
- Case Converter< 1 %
- Row Filter (Labs)< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
DB Insert< 1 %- Parameterized DB Query Reader< 1 %
DB Table Selector< 1 %Read Excel Sheet Names (XLS)< 1 %- Java IF (Table)< 1 %
- Sentence Extractor< 1 %
- List Files/Folders< 1 %
- Column Selection Configuration< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- R Source (Table)< 1 %
- R Snippet< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
01_DateTime_ManipulationKNIME Hub- 01_DateTime_Manipulation - SolutionKNIME Hub
- 01_DateTime_Manipulation - SolutionKNIME Hub
- 06_Manipulating_Date_and_Time_ValuesKNIME Hub
- 06_Manipulating_Date_and_Time_ValuesKNIME Hub
- Show all 17 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.