This node converts columns from the old Date&Time data type to the new types. It is only useful if you have to use nodes that have not been adapted to the new Date&Time type yet.
Options
Column Selection
Replace/Append Selection
New Type Selection
Time Zone Selection
Popular Predecessors
- String to Date/Time (legacy)11 %
- Date&Time to legacy Date&Time9 %
- Joiner5 %
- String to Date&Time4 %
- Column Resorter3 %
CSV Writer3 %- Column Filter3 %
Column Rename3 %- Rule Engine2 %
- Modify Date2 %
Row Filter (deprecated)2 %- Rule-based Row Filter2 %
- GroupBy2 %
- Java Snippet2 %
- Concatenate2 %
Joiner1 %- Constant Value Column1 %
- Duplicate Row Filter1 %
Number To String1 %- Row Sampling1 %
- Mask Date/Time (legacy)1 %
- String Replacer1 %
Python Script (1⇒1)1 %Database Reader< 1 %Column Appender< 1 %Table Reader< 1 %- Sorter< 1 %
- Create Date&Time Range< 1 %
- Date&Time Difference< 1 %
Concatenate (Optional in)< 1 %- Date/Time Shift (legacy)< 1 %
- DB Update< 1 %
Parameterized Database Query< 1 %- DB Reader< 1 %
CSV Reader< 1 %- Legacy Date&Time to Date&Time< 1 %
- Column Merger< 1 %
Excel Writer (XLS)< 1 %- Column Rename (Regex)< 1 %
- String Manipulation< 1 %
- Column Expressions< 1 %
- Column Renamer< 1 %
- Cross Joiner< 1 %
- Rule-based Row Splitter< 1 %
- Date Field Extractor (legacy)< 1 %
- Nominal Value Row Filter< 1 %
- Auto-Binner< 1 %
- Cell Splitter< 1 %
- Excel Reader< 1 %
Database Connection Table Reader< 1 %- Group Loop Start< 1 %
- Column Combiner< 1 %
- Number Rounder< 1 %
- Date&Time Shift< 1 %
- Number to String< 1 %
- String to Number< 1 %
Variable to Table Column< 1 %Loop End< 1 %String To Number< 1 %- Double to Integer< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Filter< 1 %
- DB Query Reader< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet (simple)< 1 %
Extract Date&Time Fields< 1 %- Time Difference (legacy)< 1 %
- String to Number (PMML)< 1 %
- Date Extractor< 1 %
Database Looping< 1 %- Column Auto Type Cast< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Splitter< 1 %
- Pivot< 1 %
- Missing Value< 1 %
- Empty Table Switch< 1 %
- Date&Time to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Modify Time Zone< 1 %
- Time Generator (legacy)< 1 %
- RowID< 1 %
- Date&Time Configuration< 1 %
- Modify Time< 1 %
- CSV Reader< 1 %
- Table Reader< 1 %
- Loop End< 1 %
- Files/Folders Meta Info< 1 %
- Date&Time Part Extractor< 1 %
- Row Filter (Labs)< 1 %
Cell Splitter< 1 %- Value Filter (legacy)< 1 %
Table Row To Variable Loop Start< 1 %- Column Splitter< 1 %
- Preset Date/Time (legacy)< 1 %
- Column Appender< 1 %
- Category to Number< 1 %
Variable to Table Row< 1 %- Lag Column< 1 %
- Table Transposer< 1 %
- Counter Generation< 1 %
- JSON to Table< 1 %
- Variable Creator< 1 %
- Table Manipulator< 1 %
- Global Timer Info< 1 %
- Duration to String< 1 %
- File Meta Info (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Database Delete< 1 %- Case Converter< 1 %
- Column Renamer (Dictionary)< 1 %
- Normalizer< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- End IF< 1 %
- Moving Average< 1 %
- Try (Data Ports)< 1 %
Table Row to Variable< 1 %- Column Comparator< 1 %
- Reference Column Resorter< 1 %
- Ungroup< 1 %
- Column Filter Configuration< 1 %
- Random Forest Predictor (Regression)< 1 %
Cell Replacer< 1 %- Column Aggregator< 1 %
- Cache< 1 %
Excel Reader (XLS)< 1 %- Extract Time Window (legacy)< 1 %
- Split Collection Column< 1 %
- Breakpoint< 1 %
Database Update< 1 %File Reader< 1 %- Table Creator< 1 %
- Chunk Loop Start< 1 %
Recursive Loop End< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Domain Calculator< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Nominal Value Row Splitter< 1 %
- Missing Value (Apply)< 1 %
Number To String (PMML)< 1 %- Rank< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Spark to Table< 1 %
- DB Writer< 1 %
- Random Matcher< 1 %
Excel Reader (XLS)< 1 %- External SSH Tool< 1 %
- N Chars Filter< 1 %
- Strings to Document< 1 %
- Column Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
Python Script (2⇒1)< 1 %- Duration to Number< 1 %
- String to Duration< 1 %
- Window Loop Start< 1 %
- Time Field Extractor (legacy)< 1 %
- Time to String (legacy)< 1 %
- XPath< 1 %
- Feed Parser< 1 %
- File Reader< 1 %
- Partitioning< 1 %
- IF Switch< 1 %
- Parallel Chunk End< 1 %
- Python Source (legacy)< 1 %
- Twitter Search< 1 %
Views
- This node has no views
Workflows
01 Taxi Demand Prediction on Spark TrainingKNIME Hub- 02 Taxi Demand Prediction on Spark DeploymentKNIME Hub
- Adding missing values based on previous row valueKNIME Forum
- Adding missing values based on previous row value - with contiguous missing valuesKNIME Forum
- Archive old records from CSV filesKNIME Forum
- Show all 52 workflows
Links
- can’t convert string in date timeby armingrudd on 2020-01-20forum.knime.com/p/79260
- Date Time Calculation helpby quaeler on 2020-06-12forum.knime.com/p/94208
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.