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 Successors
- Joiner8 %
- GroupBy7 %
- Date&Time Part Extractor5 %
- Date&Time Difference4 %
Column Rename3 %Row Filter (deprecated)3 %- Concatenate3 %
- Rule-based Row Filter3 %
- Column Filter2 %
- Rule Engine2 %
- Excel Writer2 %
- Date&Time Shift2 %
- Date&Time-based Row Filter2 %
- Date&Time to String2 %
- Column Expressions2 %
- String Manipulation1 %
- Modify Time1 %
- DB Writer1 %
- Modify Date1 %
- Cross Joiner1 %
- Column Resorter1 %
- String to Date&Time1 %
Number To String< 1 %- Table Manipulator< 1 %
- Constant Value Column< 1 %
- Duplicate Row Filter< 1 %
- Modify Time Zone< 1 %
- String to Number< 1 %
- Sorter< 1 %
- Double to Integer< 1 %
- Reference Row Filter< 1 %
- Cell Splitter< 1 %
- R Snippet< 1 %
- Missing Value< 1 %
Row Splitter (deprecated)< 1 %Excel Writer (XLS)< 1 %- Nominal Value Row Splitter< 1 %
- Rule-based Row Splitter< 1 %
- CSV Writer< 1 %
Table Writer< 1 %- Group Loop Start< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Nominal Value Row Filter< 1 %
- Unpivot< 1 %
- Duration to Number< 1 %
Extract Date&Time Fields< 1 %Table Column to Variable< 1 %- Table Row to Variable< 1 %
Database Writer< 1 %- Chunk Loop Start< 1 %
- Column Comparator< 1 %
- Column Renamer< 1 %
- One to Many< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Value Counter< 1 %
- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
Database Table Creator< 1 %- Case Converter< 1 %
- Table Validator (Reference)< 1 %
- Pivot< 1 %
- Number to String (PMML)< 1 %
- String Manipulation (Variable)< 1 %
- End IF< 1 %
- Parallel Chunk End< 1 %
DB Table Creator< 1 %- Line Chart (JFreeChart)< 1 %
- Line Plot (JavaScript)< 1 %
Table Row to Variable< 1 %- Lag Column< 1 %
- Reference Column Resorter< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Math Formula< 1 %
- RegEx Filter< 1 %
- Interactive Value Filter Widget< 1 %
Regex Extractor< 1 %- Table Column to Variable< 1 %
Table Row to Variable< 1 %CSV Writer< 1 %Database Update< 1 %Database Looping< 1 %- Table Writer< 1 %
- Java Snippet< 1 %
- Loop End< 1 %
Loop End< 1 %Generic Loop Start< 1 %- Table Row to Variable Loop Start< 1 %
- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Number to String< 1 %
- Column Appender< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Domain Calculator< 1 %
- Row Filter (Labs)< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Rank< 1 %
- Number Rounder< 1 %
- Row Aggregator< 1 %
- RowID< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Table Transposer< 1 %
- Statistics< 1 %
- Pie Chart< 1 %
- Parquet Writer< 1 %
- DB Insert< 1 %
- DB Loader< 1 %
- DB Merge< 1 %
- DB Update< 1 %
- DB Table Creator< 1 %
- Math Formula (Multi Column)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Send to Tableau Server< 1 %
- Strings to Document< 1 %
- Google Sheets Updater< 1 %
- Lift Chart (JavaScript)< 1 %
- R View (Table)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Duration< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Extract Duration Fields< 1 %
- Date Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Average< 1 %
- Collection to String< 1 %
Cell Replacer< 1 %- Row Splitter (Labs)< 1 %
- Partitioning< 1 %
- Data Explorer< 1 %
- Cache< 1 %
- Line Plot (Plotly)< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Table to Event Log< 1 %
Variable to Table Column< 1 %- Table Creator< 1 %
- Column List Loop Start< 1 %
- Column Auto Type Cast< 1 %
- Rule Engine (Dictionary)< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Spec< 1 %
- DB Table Selector< 1 %
- One Row to Many< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Table View (JavaScript)< 1 %
- Time Difference (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
Table Row To Variable Loop Start< 1 %Database Drop Table< 1 %- CSV Reader< 1 %
Recursive Loop Start< 1 %- SMOTE< 1 %
- Binner (Dictionary)< 1 %
Column Appender< 1 %- Constant Value Column Filter< 1 %
- Color Manager< 1 %
DB Loader< 1 %- Similarity Search< 1 %
- Interval Chart (JFreeChart)< 1 %
Excel Reader (XLS)< 1 %Python Script (2⇒1)< 1 %IF Switch (Flow Variable Value)< 1 %Python Snippet< 1 %- R Snippet< 1 %
- URL to File Path< 1 %
Variable to Table Column< 1 %- Variable to Table Column< 1 %
Table Column to Variable< 1 %- ARFF Writer< 1 %
Database Delete< 1 %Parameterized Database Query< 1 %Table Reader< 1 %- Decision Tree Learner< 1 %
Concatenate (Optional in)< 1 %- Bootstrap Sampling< 1 %
Cell Splitter< 1 %String To Number< 1 %- String Splitter (Regex)< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- Target Shuffling< 1 %
Rank Correlation< 1 %- Data Generator< 1 %
- Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- Histogram (legacy)< 1 %
- Interactive Table (legacy)< 1 %
Parquet Writer< 1 %Parquet Writer< 1 %- Parallel Chunk Start< 1 %
- Parameterized DB Query Reader< 1 %
- Conditional Label Assigner< 1 %
- Random Matcher< 1 %
- TimeDelay Loop End< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
Send to Power BI< 1 %- Java Snippet (simple)< 1 %
- Tableau Writer< 1 %
- Replacer< 1 %
- Bag Of Words Creator< 1 %
- Document Data Assigner< 1 %
- Document Data Extractor< 1 %
- Path to String< 1 %
- String to Path (Variable)< 1 %
- Google Sheets Writer< 1 %
- Column Filter (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Container Output (Table)< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
Python Script (1⇒1)< 1 %- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Anonymization< 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.