This node converts columns from the new Date&Time data types to the legacy type. 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
Time Zone Handling
Popular Successors
- Legacy Date&Time to Date&Time11 %
- Modify Date3 %
- Joiner3 %
- Date&Time Part Extractor3 %
String To Number2 %- String to Date&Time2 %
- Date&Time-based Row Filter2 %
- Concatenate2 %
- Rule Engine2 %
- Date&Time Difference2 %
- Modify Time2 %
- Mask Date/Time (legacy)2 %
- Cross Joiner1 %
- DB Loader1 %
Database Writer1 %Column Rename1 %- Date Field Extractor (legacy)1 %
- Double to Integer1 %
- GroupBy1 %
- Rule-based Row Filter1 %
- Date&Time to String1 %
- Excel Writer1 %
- DB Writer< 1 %
Cell Replacer< 1 %Column Appender< 1 %- Table Validator (Reference)< 1 %
- Reference Row Filter< 1 %
- Table Row to Variable< 1 %
- Cell Splitter< 1 %
Row Filter (deprecated)< 1 %- Date&Time to legacy Date&Time< 1 %
- CSV Writer< 1 %
- Table Manipulator< 1 %
- Extract Duration Fields< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
Table Row To Variable Loop Start< 1 %- Column Filter< 1 %
CASE Switch Data (End)< 1 %- Column Expressions (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Java Snippet< 1 %
- Sorter< 1 %
- Column Splitter< 1 %
- Rule-based Row Splitter< 1 %
- DB Insert< 1 %
Python Script (1⇒1)< 1 %- Nominal Value Row Filter< 1 %
- Cell Splitter By Position< 1 %
- Constant Value Column< 1 %
- Missing Value< 1 %
Excel Sheet Appender (XLS)< 1 %- Send to Power BI< 1 %
- R Snippet< 1 %
Extract Date&Time Fields< 1 %- Date/Time Shift (legacy)< 1 %
Loop End< 1 %- Pivot< 1 %
Excel Writer (XLS)< 1 %- Line Plot (JavaScript)< 1 %
- Preset Date/Time (legacy)< 1 %
- Loop End< 1 %
Number To String< 1 %- Column Appender< 1 %
- Lag Column< 1 %
- String Manipulation< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Color Manager< 1 %
- UNIX Timestamp to Date&Time< 1 %
- TIBCO Spotfire File Writer< 1 %
- Extract Variables (Data)< 1 %
CSV Writer< 1 %Database Looping< 1 %- Group Loop Start< 1 %
- Binner (Dictionary)< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Column Resorter< 1 %
- Duplicate Row Filter< 1 %
Row Splitter (deprecated)< 1 %Joiner< 1 %- Table Difference Finder< 1 %
- Statistics< 1 %
DB Table Creator< 1 %- Math Formula< 1 %
- Interval Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table to JSON< 1 %
- Date&Time Shift< 1 %
- Modify Time Zone< 1 %
- Time Difference (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Chunk Loop Start< 1 %
- k-Means< 1 %
- Column Combiner< 1 %
- Reference Row Splitter< 1 %
- Rank< 1 %
- Top k Row Filter< 1 %
- Data Explorer< 1 %
- Scatter Plot (legacy)< 1 %
Microsoft SQL Server Connector< 1 %- Java Snippet Row Splitter< 1 %
- Tableau Writer< 1 %
- Strings to Document< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Table to R< 1 %
- Duration to Number< 1 %
- String to Duration< 1 %
- Date Extractor< 1 %
- ARIMA Learner< 1 %
- Table Row to Variable Loop Start< 1 %
- String to Number< 1 %
- Column Rename (Regex)< 1 %
- Partitioning< 1 %
- Number Rounder< 1 %
- String Manipulation (Multi Column)< 1 %
DB Loader< 1 %- Line Chart (JFreeChart)< 1 %
- Java Snippet (simple)< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- R View (Table)< 1 %
- GET Request< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %Database Delete< 1 %Table Writer< 1 %- Case Converter< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- Linear Correlation< 1 %
- Domain Calculator< 1 %
- Reference Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Normalizer< 1 %
- End IF< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
- Interactive Table (legacy)< 1 %
- Parallel Chunk End< 1 %
- Parameterized DB Query Reader< 1 %
- Counter Generation< 1 %
- Continuous Error Plot (Plotly)< 1 %
Excel Writer (XLS)< 1 %Tableau Writer (Hyper)< 1 %- Heatmap (JavaScript)< 1 %
- Data Row to Image< 1 %
- Table Difference Checker< 1 %
- Table to HTML String< 1 %
- Split Interval< 1 %
- 2D/3D Scatterplot< 1 %
- String to URI< 1 %
- Wait...< 1 %
- Try (Data Ports)< 1 %
- Variable to Table Column< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Database Row Filter< 1 %Database SQL Executor< 1 %Database Update< 1 %Database Table Creator< 1 %- Table Creator< 1 %
- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Fuzzy Rule Learner< 1 %
- Linear Regression Learner< 1 %
- Random Forest Predictor< 1 %
Concatenate (Optional in)< 1 %- Category to Number (Apply)< 1 %
- Category to Number< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Extract Missing Value Cause< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Missing Value (Apply)< 1 %
- RowID< 1 %
- String Manipulation (Variable)< 1 %
- Value Counter< 1 %
- Kaplan-Meier Estimator< 1 %
- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
- Interactive Histogram (legacy)< 1 %
- Line Plot (legacy)< 1 %
Hive Loader (legacy)< 1 %PostgreSQL Connector< 1 %- DB Merge< 1 %
- DB Table Creator< 1 %
- Random Boolean Assigner< 1 %
- Time Series Generator< 1 %
- Line Plot (Plotly)< 1 %
- Table to H2O< 1 %
- Math Formula (Multi Column)< 1 %
- Math Formula (Variable)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
XLS Writer< 1 %Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %TIBCO File Writer< 1 %Send to Tableau Server (Hyper)< 1 %- Google Sheets Updater< 1 %
- Google Sheets Writer< 1 %
- Date&Time Configuration< 1 %
- Lift Chart (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- String to JSON< 1 %
- JSON Path< 1 %
Python Script (1⇒2)< 1 %Python Script (2⇒2)< 1 %- Python View (legacy)< 1 %
- Add Table to R< 1 %
- Data to Report (BIRT)< 1 %
- Window Loop Start< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
Views
- This node has no views
Workflows
Analyze and manage your sports data by Ángel MolinaKNIME Hub- Date_TimeKNIME Forum
- Get New quantilope users - workflowKNIME Hub
- kn_example_r_date_formats_extendedKNIME Hub
- KNIME_batchingV2KNIME Forum
- Show all 11 workflows
Links
- Date format changed to yyyy-mm-dd from dd-mm-yyyy when using “string to date/time” node?by armingrudd on 2019-05-15forum.knime.com/p/60538
- Current date formatby armingrudd on 2020-01-11forum.knime.com/p/78535
- Converting Dates during ETL proceduresby Andrew_Steel on 2019-10-05forum.knime.com/p/71755
- Issue with Send to Power BI Node Datesby armingrudd on 2020-03-07forum.knime.com/p/83659
- Checking csv file for ASCII Characters and getting java errorby izaychik63 on 2020-07-29forum.knime.com/p/98440
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.