Modifies date&time columns in three different ways. The
node can append a time to local date columns (output type is local or
zoned date time column)
or
change the time in local or zoned date&time columns
or remove the time from local or zoned date&time columns
(output type is local date).
This node is not used to add ("plus") or subtract ("minus") time. Use
the
Date&Time Shift
node for that.
Options
Column Selection
Replace/Append Selection
Time Selection
Popular Predecessors
- String to Date&Time12 %
Excel Reader (XLS)7 %- Modify Date4 %
Row Filter (deprecated)4 %- Missing Value3 %
- Excel Reader3 %
- Joiner3 %
- GroupBy3 %
- Date&Time Difference2 %
Column Rename2 %- Rule-based Row Filter2 %
Excel Writer (XLS)2 %- Create Date&Time Range2 %
- Date&Time Shift2 %
- Modify Time Zone2 %
- Modify Time2 %
- Column Filter2 %
- Date&Time Part Extractor2 %
- Date&Time to legacy Date&Time2 %
- Column Resorter1 %
- Concatenate1 %
- Rule Engine1 %
- String Manipulation< 1 %
- Number to String< 1 %
- DB Reader< 1 %
- Variable to Table Row< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Loop End< 1 %
String To Number< 1 %- Sorter< 1 %
- Math Formula< 1 %
- Table Manipulator< 1 %
- Table Creator< 1 %
Extract Date&Time Fields< 1 %- Date Extractor< 1 %
- File Meta Info (legacy)< 1 %
Joiner< 1 %- Duplicate Row Filter< 1 %
Row Splitter (deprecated)< 1 %- String to Number< 1 %
- Table Reader< 1 %
- DB Query Reader< 1 %
- CSV Reader< 1 %
- Date&Time-based Row Filter< 1 %
- Number Rounder< 1 %
- Timer Info< 1 %
CSV Reader< 1 %- Column Expressions< 1 %
Excel Reader (XLS)< 1 %- Table Row to Variable< 1 %
Loop End< 1 %- Constant Value Column< 1 %
- String Manipulation (Variable)< 1 %
Strings To Document< 1 %- Cell Splitter< 1 %
- Cross Joiner< 1 %
- Nominal Value Row Filter< 1 %
- Statistics< 1 %
- Date&Time to String< 1 %
- Denormalizer< 1 %
Database Reader< 1 %- Double to Integer< 1 %
- Time Generator (legacy)< 1 %
- Moving Aggregator< 1 %
- File Reader< 1 %
- Column Appender< 1 %
- Row Filter (Labs)< 1 %
- Unpivot< 1 %
- Files/Folders Meta Info< 1 %
- Rank< 1 %
- IF Switch< 1 %
- Column Merger< 1 %
- Reference Row Filter< 1 %
- Pivot< 1 %
- String Replacer< 1 %
- UNIX Timestamp to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Table Row to Variable< 1 %- Java Snippet< 1 %
Cell Replacer< 1 %Number To String< 1 %- Column Renamer (Dictionary)< 1 %
- Rule-based Row Splitter< 1 %
- Math Formula (Multi Column)< 1 %
- Row Splitter (Labs)< 1 %
- String Manipulation (Multi Column)< 1 %
- Python Script (legacy)< 1 %
- DB Connection Closer< 1 %
- Nominal Row Filter Configuration< 1 %
- Table Transposer< 1 %
- Column Renamer< 1 %
- Mask Date/Time (legacy)< 1 %
Table Reader< 1 %- Column Rename (Regex)< 1 %
- Date&Time Input (legacy)< 1 %
Recursive Loop Start< 1 %- Column Splitter< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Missing Value Column Filter< 1 %
Parquet Reader< 1 %- String to Duration< 1 %
- Group Loop Start< 1 %
Variable to Table Row< 1 %Concatenate (Optional in)< 1 %File Reader< 1 %- Table Validator (Reference)< 1 %
- RowID< 1 %
- Empty Table Switch< 1 %
- JSON to Table< 1 %
Python Script (1⇒1)< 1 %- Duration to String< 1 %
- Duration to Number< 1 %
- Case Converter< 1 %
- Reference Column Filter< 1 %
- Ungroup< 1 %
Database Connection Table Reader< 1 %- Benchmark End< 1 %
Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %- Extract System Properties< 1 %
- Column Combiner< 1 %
- Column Aggregator< 1 %
- Constant Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Rule Engine (Dictionary)< 1 %
- Parameterized DB Query Reader< 1 %
- SAS7BDAT Reader< 1 %
- Java IF (Table)< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
JSON Reader< 1 %- Python Source (legacy)< 1 %
- R Snippet< 1 %
- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Take Screenshot< 1 %
- Category to Number< 1 %
Parquet Reader< 1 %- Parallel Chunk End< 1 %
- PDF Parser< 1 %
- Bag Of Words Creator< 1 %
- Date&Time Configuration< 1 %
- Line Plot (JavaScript)< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- String to XML< 1 %
- Web Page Content Extractor< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
00_Progress_Tracker_Supply_Logistics_ExampleKNIME Hub- 00_Progress_Tracker_Supply_Logistics_ExampleKNIME Hub
- 01 Data and Time and DatabasesKNIME Hub
- 01 Date and Time and DatabasesKNIME Hub
- 01 Date and Time and DatabasesKNIME Hub
- Show all 326 workflows
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.