Parses the strings in the selected columns and converts them into Date&Time cells. The expected format can be selected from a number of commonly used formats or specified manually (see section "Type and Format Selection").
Since dates may contain localized terms such as month or weekday names, you can additionally specify a locale.
Options
Column Selection
Replace/Append Selection
Type and Format Selection
Abort Execution
Popular Predecessors
- String Manipulation11 %
Row Filter (deprecated)6 %- Column Filter5 %
- CSV Reader5 %
- Excel Reader4 %
- Date&Time to String4 %
- Number to String3 %
Column Rename3 %- Rule Engine3 %
- GroupBy3 %
- String to Number3 %
- Column Expressions3 %
- String to Date&Time3 %
- Concatenate3 %
- Rule-based Row Filter2 %
- Constant Value Column2 %
- Cell Splitter2 %
- String Manipulation (Multi Column)2 %
- Column Combiner2 %
- Duplicate Row Filter1 %
- Column Resorter1 %
- Missing Value1 %
- File Reader1 %
- Table Creator1 %
Row Splitter (deprecated)1 %- Math Formula1 %
- String Replacer1 %
- Rule-based Row Splitter< 1 %
- Column Renamer< 1 %
- DB Query Reader< 1 %
- Sorter< 1 %
- Loop End< 1 %
- Table Manipulator< 1 %
- Date&Time Part Extractor< 1 %
- String to Date/Time (legacy)< 1 %
- Column Auto Type Cast< 1 %
- Unpivot< 1 %
- Date&Time Shift< 1 %
- Nominal Value Row Filter< 1 %
- Create Date&Time Range< 1 %
- DB Reader< 1 %
- Reference Row Filter< 1 %
- Java Snippet< 1 %
- Number Rounder< 1 %
- Pivot< 1 %
- Variable to Table Row< 1 %
- Column Aggregator< 1 %
- Column Merger< 1 %
- Google Sheets Reader< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Modify Date< 1 %
- JSON Path< 1 %
- Cell Splitter By Position< 1 %
- Cross Joiner< 1 %
- Date&Time-based Row Filter< 1 %
- File Reader (Complex Format)< 1 %
- Table Reader< 1 %
- Column Renamer (Dictionary)< 1 %
- Date&Time Difference< 1 %
- Missing Value Column Filter< 1 %
Joiner< 1 %- RowID< 1 %
- Date&Time Configuration< 1 %
Number To String (PMML)< 1 %- Ungroup< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Time< 1 %
Excel Writer (XLS)< 1 %- Column Splitter< 1 %
Cell Replacer< 1 %- Column Appender< 1 %
File Reader< 1 %- Variable to Table Column< 1 %
Table Row to Variable< 1 %- String Splitter (Regex)< 1 %
- Nominal Value Row Splitter< 1 %
- Number to String (PMML)< 1 %
- Table View (JavaScript)< 1 %
- String to Number (PMML)< 1 %
- Row to Column Names< 1 %
- Group Loop Start< 1 %
- Case Converter< 1 %
Variable to Table Column< 1 %- Parquet Reader< 1 %
Database Connection Table Reader< 1 %- Table Transposer< 1 %
Database Looping< 1 %- Row Filter (Labs)< 1 %
Excel Reader (XLS)< 1 %- CSV Writer< 1 %
- Empty Table Switch< 1 %
- Math Formula (Multi Column)< 1 %
- Table Row to Variable< 1 %
- Regex Extractor< 1 %
- String Replacer (Dictionary)< 1 %
- Rule Engine (Dictionary)< 1 %
- Date&Time Input (legacy)< 1 %
- Chunk Loop Start< 1 %
- Strings to Document< 1 %
- Date&Time Widget< 1 %
- Date Extractor< 1 %
- Missing Value (Apply)< 1 %
- Add Empty Rows< 1 %
- Data Generator< 1 %
- Interactive Table (legacy)< 1 %
- Generic Loop Start< 1 %
- Column Rename (Regex)< 1 %
- Google Analytics Query (legacy)< 1 %
- Container Input (JSON)< 1 %
- Extract Duration Fields< 1 %
- XML to JSON< 1 %
- R Snippet< 1 %
Table Row To Variable Loop Start< 1 %- Column List Loop Start< 1 %
- Lag Column< 1 %
- IF Switch< 1 %
- JSON to Table< 1 %
- Category to Number< 1 %
Number To String< 1 %String To Number (PMML)< 1 %- Row Sampling< 1 %
- String Input (legacy)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Value Filter (legacy)< 1 %
- Moving Aggregator< 1 %
- Scorer< 1 %
- Path to String< 1 %
Loop End< 1 %String To Number< 1 %- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Statistics< 1 %
- Twitter Retweet Search< 1 %
- URL to File Path< 1 %
Generic Loop Start< 1 %- DB Writer< 1 %
- Capture Workflow Start< 1 %
- CASE Switch End< 1 %
- Excel Writer< 1 %
- Catch Errors (Data Ports)< 1 %
Table Column to Variable< 1 %- Auto-Binner< 1 %
Column Appender< 1 %- Normalizer< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- R Snippet< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Time Generator (legacy)< 1 %
- Binary Objects to Strings< 1 %
Table Row to Variable< 1 %Simple File Reader< 1 %- Cache< 1 %
- Timer Info< 1 %
- Window Loop Start< 1 %
- Multiport Loop End< 1 %
- Wait...< 1 %
- Row Splitter (Labs)< 1 %
- Tableau Writer< 1 %
Variable to Table Row< 1 %Database Writer< 1 %- Loop End (Column Append)< 1 %
Recursive Loop Start< 1 %- Constant Value Column Filter< 1 %
String Replace (Dictionary)< 1 %- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Twitter Search< 1 %
- XPath< 1 %
- Column Name Extractor< 1 %
- Create Table Structure< 1 %
- Table Validator (Reference)< 1 %
- Joiner< 1 %
- Numeric Row Splitter< 1 %
- Replacer< 1 %
- Column Filter Configuration< 1 %
- String to Duration< 1 %
- Extract Time Window (legacy)< 1 %
Regex Extractor< 1 %- Variable Creator< 1 %
- Recursive Loop End< 1 %
- Variable Loop End< 1 %
- Reference Column Splitter< 1 %
- CASE Switch Start< 1 %
Parquet Reader< 1 %- DB Insert< 1 %
- List Files/Folders< 1 %
- Binary Objects to Files< 1 %
- Auto-Binner (Apply)< 1 %
- Parquet Writer< 1 %
- Recursive Loop Start< 1 %
- Value Lookup< 1 %
- Google Analytics Query< 1 %
- Multiple Selection Widget< 1 %
- Create Collection Column< 1 %
- Split Collection Column< 1 %
- Strings to Binary Objects< 1 %
- Try (Data Ports)< 1 %
- Inject Variables (Data)< 1 %
CSV Reader< 1 %Database Reader< 1 %Table Reader< 1 %- Regression Predictor< 1 %
- Numeric Binner< 1 %
Cell Splitter< 1 %- One to Many< 1 %
- Domain Calculator< 1 %
- Equal Size Sampling< 1 %
- Filter Apply< 1 %
- Reference Row Splitter< 1 %
- Partitioning< 1 %
- Reference Column Resorter< 1 %
- String Manipulation (Variable)< 1 %
CASE Switch Data (Start)< 1 %Merge Variables< 1 %- Color Manager< 1 %
- Parallel Chunk Start< 1 %
- Counter Generation< 1 %
Excel Reader (XLS)< 1 %- Java Snippet (simple)< 1 %
- Java IF (Table)< 1 %
- RegEx Filter< 1 %
- Column Filter (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- R Predictor< 1 %
- R Source (Table)< 1 %
- R to Table< 1 %
Extract Date&Time Fields< 1 %- Time to String (legacy)< 1 %
- Read Variables< 1 %
- Collection to String< 1 %
- Combine Columns by Header< 1 %
Variable to Table Row< 1 %- Fixed Width File Reader< 1 %
- Extract Missing Value Cause< 1 %
- Rank< 1 %
- Top k Row Filter< 1 %
- Value Counter< 1 %
- Data Explorer< 1 %
- Numeric Outliers< 1 %
- End IF< 1 %
- Parameterized DB Query Reader< 1 %
- Random Number Assigner< 1 %
- Math Formula (Variable)< 1 %
- Tika Parser URL Input< 1 %
- String Configuration< 1 %
- Scatter Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- String to JSON< 1 %
- Duration to String< 1 %
- Modify Time Zone< 1 %
- Remove Empty Rows< 1 %
- Table Column to Variable< 1 %
- Table Row to Variable Loop Start< 1 %
- Linear Correlation< 1 %
- Merge Variables< 1 %
- Variable Expressions< 1 %
- Files/Folders Meta Info< 1 %
- Column Selection Widget< 1 %
- Python Script (legacy)< 1 %
- String to Path< 1 %
Variable Condition Loop End< 1 %Concatenate (Optional in)< 1 %- Column Comparator< 1 %
- Target Shuffling< 1 %
- Java Snippet Row Filter< 1 %
Python Script (1⇒1)< 1 %- Benchmark Start< 1 %
- Line Chopper< 1 %
- Shuffle< 1 %
- Extract Table Dimension< 1 %
- Spark to Table< 1 %
- DB SQL Executor< 1 %
- SAS7BDAT Reader< 1 %
Excel Writer (XLS)< 1 %- Moving Average< 1 %
XML Reader< 1 %Recursive Loop End (2 ports)< 1 %- X-Partitioner< 1 %
- Dictionary Replacer< 1 %
- Outlier Removal< 1 %
- Java Snippet Row Splitter< 1 %
- Unzip Files (legacy)< 1 %
- Active Branch Inverter< 1 %
Database Delete< 1 %- Java Edit Variable< 1 %
Loop End (2 ports)< 1 %- Random Forest Predictor (Regression)< 1 %
- Number to Category (Apply)< 1 %
ORC Reader< 1 %- DB Update< 1 %
- List Box Input (legacy)< 1 %
- Duration to Number< 1 %
- Markup Tag Filter< 1 %
- DELETE Request< 1 %
- URL to File Path (Variable)< 1 %
- Breakpoint< 1 %
Extract Context Properties< 1 %List Files< 1 %Parquet Reader< 1 %- Twitter Timeline< 1 %
- TIBCO Spotfire File Reader< 1 %
- Benchmark End< 1 %
- Download / Upload from List (legacy)< 1 %
Parameterized Database Query< 1 %Counting Loop Start< 1 %- Table Validator< 1 %
- Edit Nominal Domain< 1 %
- Normalizer (PMML)< 1 %
- Extract Table Spec< 1 %
- Boolean Input (legacy)< 1 %
Python Script (2⇒1)< 1 %- RDKit Fingerprint< 1 %
Flow Variable IF Switch< 1 %- String to URI< 1 %
- Try (Variable Ports)< 1 %
- Rule Engine Variable< 1 %
- Rank Correlation< 1 %
- Save Workflow< 1 %
- DB Connection Closer< 1 %
- Anonymization< 1 %
Variable to Table Column< 1 %Recursive Loop End< 1 %- DBSCAN< 1 %
- HiLite Row Splitter< 1 %
CASE Switch Data (End)< 1 %- Parallel Chunk End< 1 %
- Random Label Assigner< 1 %
Python Script (1⇒2)< 1 %- Latitude/Longitude to Coordinate< 1 %
IF Switch (Flow Variable Value)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Benchmark Start (Memory Monitoring)< 1 %
- Collection Size< 1 %
- URL Encode< 1 %
- Number Formatter< 1 %
- Table to String< 1 %
- File Meta Info (legacy)< 1 %
- URI Port to Variable< 1 %
- Create File Name (legacy)< 1 %
- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %- ARFF Reader< 1 %
SQL Extract< 1 %Database Table Selector< 1 %Database Pivot< 1 %Recursive Loop Start (2 ports)< 1 %- k-Means< 1 %
- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- SMOTE< 1 %
- Random Forest Predictor< 1 %
- Binner (Dictionary)< 1 %
- Many to One< 1 %
- Subset Matcher< 1 %
- Column Filter (PMML)< 1 %
- Nominal Probability Distribution Splitter< 1 %
- Create Temp Dir (legacy)< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
Color Appender< 1 %- SDF Reader< 1 %
- TimeDelay Loop End< 1 %
- Geo-Coordinate Row Filter< 1 %
- Java Edit Variable (simple)< 1 %
- Punctuation Erasure< 1 %
Stop Word Filter< 1 %- PDF Parser< 1 %
- Tika Parser< 1 %
- RSS Feed Reader< 1 %
- Document Data Extractor< 1 %
- Term to String< 1 %
- Google Sheets Updater< 1 %
Column Selection Configuration< 1 %- CSS Editor< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Integer Widget< 1 %
- Table to JSON< 1 %
MongoDB Reader< 1 %Python Script (2⇒2)< 1 %- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
- Disturber Node< 1 %
- Fail in execution< 1 %
- Time Difference (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
Twitter Streaming< 1 %- Twitter Users< 1 %
- Web Log Reader< 1 %
- String to XML< 1 %
- OPSIN< 1 %
- HTTP Result Data Extractor< 1 %
Table Extractor< 1 %- Table Merger< 1 %
- Delete Files (legacy)< 1 %
- Download (legacy)< 1 %
- Catch Errors (Generic Ports)< 1 %
Table Column to Variable< 1 %- Line Reader< 1 %
Table Writer< 1 %- Counting Loop Start< 1 %
- Perl Scripting< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Numeric Outliers (Apply)< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Merge< 1 %
- DB Query Extractor< 1 %
- Empty Table Creator< 1 %
- Random Label Assigner (Data)< 1 %
- OSM Map to Image< 1 %
- Number Filter< 1 %
- Create File/Folder Variables< 1 %
- Delete Files/Folders< 1 %
- Boolean Configuration< 1 %
- Integer Configuration< 1 %
- List Box Configuration< 1 %
- Column Filter Widget< 1 %
- File Chooser Widget< 1 %
- List Box Widget< 1 %
- String Widget< 1 %
- JSON Reader< 1 %
- Columns to JSON< 1 %
- Don't Save End< 1 %
- Byte Converter< 1 %
Call Workflow Service< 1 %Column Distance< 1 %Table Extractor< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (Optional)_Linear_RegressionKNIME Hub
- [01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
- [02.CX] Viber Community Report JSON Parsing WorkflowKNIME Hub
- 0. Lubes_Sales_Pred-ModelNodePit Space
- Show all 3095 workflows
Links
- R to Table and as.Date functionby JanDuo on 2020-06-12forum.knime.com/p/94121
- Converting string to datetime with “month name”by armingrudd on 2019-09-27forum.knime.com/p/71186
- Change from number to dateby armingrudd on 2019-10-19forum.knime.com/p/72755
- Price selection on base of dateby armingrudd on 2020-04-10forum.knime.com/p/87139
- Can’t find source code for ExcelReader – XLSReaderNode**by danielesser on 2019-09-05forum.knime.com/p/69428
- Show all 15 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.