Modifies date&time columns in three different ways. The
node can add a time zone to local date&time columns or changing
the time zone in zoned date&time
columns (without adjusting the time!)
or
shift the time zone in zoned date&time columns by adjusting the
time (and potentially date)
according to the new time zone offset
or
remove the time zone from zoned date&time columns.
Options
Column Selection
Replace/Append Selection
Time Zone Selection
Popular Successors
- Modify Time Zone8 %
- Concatenate6 %
- Modify Time5 %
- Modify Date4 %
- Date&Time Shift3 %
- DB Writer3 %
- Cross Joiner3 %
- Date&Time to String3 %
Row Filter (deprecated)3 %- Date&Time Difference3 %
Table Row to Variable2 %- Joiner2 %
- Sorter2 %
Parquet Writer2 %- CSV Writer2 %
- Date&Time Part Extractor1 %
- Math Formula1 %
- Java Snippet1 %
- GroupBy1 %
- RowID1 %
- String Manipulation (Multi Column)1 %
- DB Insert1 %
- Date&Time to legacy Date&Time1 %
- UNIX Timestamp to Date&Time1 %
- Time Difference (legacy)1 %
- Duplicate Row Filter1 %
- Column Filter1 %
- String Manipulation1 %
- Rule Engine1 %
- Cell Splitter< 1 %
- Rule-based Row Filter< 1 %
- CASE Switch End< 1 %
- End IF< 1 %
- Excel Writer< 1 %
- Table Difference Checker< 1 %
- Date&Time-based Row Filter< 1 %
- Table Row to Variable< 1 %
- Recursive Loop Start< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Filter< 1 %
- Table Manipulator< 1 %
Column Rename< 1 %- Extract Table Dimension< 1 %
- DB Update< 1 %
- DB Table Creator< 1 %
- Column Expressions (legacy)< 1 %
Excel Writer (XLS)< 1 %- Tableau Writer< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Date&Time< 1 %
- Time to String (legacy)< 1 %
Loop End< 1 %Joiner< 1 %- Color Manager< 1 %
Variable to Table Column< 1 %Table Row To Variable Loop Start< 1 %- String to Number< 1 %
- Column Rename (Regex)< 1 %
- Double to Integer< 1 %
- Python Script (legacy)< 1 %
- Create Date&Time Range< 1 %
- Date Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
Database Table Creator< 1 %- Case Converter< 1 %
String To Number< 1 %- Constant Value Column< 1 %
- String Manipulation (Variable)< 1 %
DB Table Creator< 1 %- Variable Expressions (legacy)< 1 %
- Line Chart (JFreeChart)< 1 %
- Path to String (Variable)< 1 %
- Line Plot (JavaScript)< 1 %
- Date/Time Shift (legacy)< 1 %
- Copy/Move Files (legacy)< 1 %
- Table Column to Variable< 1 %
Table Row to Variable< 1 %CSV Writer< 1 %Database Writer< 1 %File Reader< 1 %- Loop End (Column Append)< 1 %
- Chunk Loop Start< 1 %
Generic Loop Start< 1 %- Group Loop Start< 1 %
- K Nearest Neighbor< 1 %
Concatenate (Optional in)< 1 %- Auto-Binner< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Lag Column< 1 %
- Column Merger< 1 %
- Missing Value< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- Renderer to Image< 1 %
- Empty Table Switch< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
PostgreSQL Connector< 1 %- DB Loader< 1 %
- DB SQL Executor< 1 %
- Distance Matrix Calculate< 1 %
- Interval Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %Tableau Writer (Hyper)< 1 %- Strings to Document< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Table to JSON< 1 %
Python Script (1⇒1)< 1 %- Table to R< 1 %
- Data to Report (BIRT)< 1 %
Extract Date&Time Fields< 1 %- Extract Duration Fields< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Table to Event Log< 1 %
Views
- This node has no views
Workflows
06_Manipulating_Date_and_Time_ValuesKNIME Hub- 06_Manipulating_Date_and_Time_ValuesKNIME Hub
- 09_Schedule_Jobs_via_WebPortal_on_KNIME_ServerKNIME Hub
- 09_Schedule_Jobs_via_WebPortal_on_KNIME_ServerKNIME Hub
- 10_GoogleBigQuery_meets_SQLiteKNIME Hub
- Show all 49 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.