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
Popular Successors
Date&Time Difference6 %- Joiner6 %
Date&Time to String4 %- Date&Time Part Extractor4 %
- Rule-based Row Filter3 %
- Rule Engine3 %
DB Loader2 %- Date&Time-based Row Filter2 %
Date&Time Shift2 %- Column Filter2 %
- GroupBy2 %
Row Filter (deprecated)2 %- Concatenate2 %
- Value Counter2 %
Column Appender2 %DB Writer1 %- String Manipulation1 %
- Excel Writer1 %
Table Row To Variable Loop Start1 %Number To String< 1 %Extract Date&Time Fields< 1 %Column Rename< 1 %ORC Writer< 1 %- R Snippet< 1 %
- Window Loop Start< 1 %
- ARIMA Learner< 1 %
- String Manipulation (Multi Column)< 1 %
DB Insert< 1 %- DB Loader< 1 %
- Time Field Extractor (legacy)< 1 %
- Create Collection Column< 1 %
- Variable to Table Column< 1 %
- Group Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Merger< 1 %
- Missing Value Column Filter< 1 %
- Create File/Folder Variables< 1 %
- Mask Date/Time (legacy)< 1 %
Table Writer< 1 %- Constant Value Row Appender< 1 %
Tableau Writer (Hyper)< 1 %- Tableau Writer< 1 %
String to Date&Time< 1 %Create Date&Time Range< 1 %Modify Time< 1 %Regression Predictor< 1 %- Column Combiner< 1 %
String To Number< 1 %- Double to Integer< 1 %
- Duplicate Row Filter< 1 %
- Normalizer< 1 %
- Set Operator< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
DB Merge< 1 %DB Table Creator< 1 %- Counter Generation< 1 %
- Java Snippet (simple)< 1 %
- Send to Tableau Server< 1 %
Python Script (1⇒1)< 1 %- Date&Time to legacy Date&Time< 1 %
Table Row to Variable< 1 %Table Row to Variable< 1 %- Table Row to Variable< 1 %
CSV Writer< 1 %Database Writer< 1 %Database Looping< 1 %- CSV Writer< 1 %
- Java Snippet< 1 %
- Loop End< 1 %
- Column List Loop Start< 1 %
- Cell Splitter< 1 %
- Column Comparator< 1 %
- Number to String< 1 %
- String to Number< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
Constant Value Column< 1 %- Cross Joiner< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Row Filter (Labs)< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
Joiner< 1 %- Pivot< 1 %
- Missing Value< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Number Rounder< 1 %
- RowID< 1 %
- Sorter< 1 %
Column Splitter< 1 %- String Manipulation (Variable)< 1 %
- Table Transposer< 1 %
- Rule-based Row Splitter< 1 %
- Data Explorer< 1 %
- Empty Table Switch< 1 %
- Extract Table Spec< 1 %
- Scatter Plot (legacy)< 1 %
DB Update< 1 %- DB Table Creator< 1 %
- Column Expressions (legacy)< 1 %
- Math Formula< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Python Script (legacy)< 1 %
Duration to Number< 1 %- Legacy Date&Time to Date&Time< 1 %
String to Duration< 1 %UNIX Timestamp to Date&Time< 1 %Extract Duration Fields< 1 %Modify Date< 1 %Modify Time Zone< 1 %- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- CSV Reader< 1 %
Loop End< 1 %- Linear Correlation< 1 %
- Table Validator (Reference)< 1 %
- String Replacer< 1 %
- Unpivot< 1 %
- Statistics< 1 %
- Interval Chart (JFreeChart)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
Python Script (2⇒1)< 1 %Counting Loop Start< 1 %- Case Converter< 1 %
Cell Replacer< 1 %- One to Many< 1 %
- Number to String (PMML)< 1 %
- Interactive Table (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
- Tika Language Detector< 1 %
- R Snippet (2:1)< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Variable to Table Column< 1 %Table Column to Variable< 1 %Database Delete< 1 %Database Update< 1 %Concatenate (Optional in)< 1 %- Cell Splitter By Position< 1 %
- Column Name Replacer< 1 %
- Table Manipulator< 1 %
- TimeDelay Loop Start< 1 %
- Bar Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %Send to Tableau Server (Hyper)< 1 %- Value Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Table Difference Checker< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Column to XML< 1 %
- Table to HTML String< 1 %
- XLS Control Table Generator< 1 %
- Try (Variable Ports)< 1 %
- Table Column to Variable< 1 %
Database Table Connector< 1 %Database Reader< 1 %Database SQL Executor< 1 %Parameterized Database Query< 1 %Database Table Creator< 1 %- Table Writer< 1 %
- Table Creator< 1 %
Loop End (2 ports)< 1 %- Chunk Loop Start< 1 %
- Generic Loop Start< 1 %
Recursive Loop Start< 1 %- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
- Numeric Binner< 1 %
- Binner (Dictionary)< 1 %
Cell Splitter< 1 %- Column Auto Type Cast< 1 %
- Category to Number< 1 %
- Column Aggregator< 1 %
- Lag Column< 1 %
- Correlation Filter< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Reference Column Filter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Nominal Value Row Splitter< 1 %
- Normalizer (Apply)< 1 %
- Table Partitioner< 1 %
- Numeric Row Splitter< 1 %
- Row Sampler< 1 %
String Replace (Dictionary)< 1 %- Target Shuffling< 1 %
- Top k Row Filter< 1 %
CASE Switch Data (End)< 1 %- End IF< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Interactive Histogram (legacy)< 1 %
Color Appender< 1 %- Color Manager< 1 %
Parquet Writer< 1 %Hive Loader (legacy)< 1 %- MySQL Connector< 1 %
- DB Connector< 1 %
- Line Plot (Plotly)< 1 %
- Scatter Plot (Plotly)< 1 %
- Generic Web Service Client< 1 %
- HeatMap (JFreeChart)< 1 %
Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %- Java Snippet Row Filter< 1 %
- Strings to Document< 1 %
- Path to String< 1 %
- Google Sheets Updater< 1 %
- CSS Editor (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- Container Output (Table)< 1 %
- Table to JSON< 1 %
- JSON to Table< 1 %
Python View< 1 %Python Script (2⇒2)< 1 %- Python Edit Variable (legacy)< 1 %
- Table to R< 1 %
- Data to Report (BIRT)< 1 %
- Extract Time Window (legacy)< 1 %
- Moving Aggregator< 1 %
Views
- This node has no views
Workflows
01 Taxi Demand Prediction on Spark TrainingKNIME Hub- 02 Taxi Demand Prediction on Spark DeploymentKNIME Hub
- 3A. Visualización de Tendencias EconómicasKNIME Hub
- Adding missing values based on previous row valueKNIME Forum
- Adding missing values based on previous row value - with contiguous missing valuesKNIME Forum
- Show all 72 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.