Parses the strings in the selected String column and converts them
into date/time cells by using the entered format pattern.
Note, the date parser uses localization settings so in order to
parse foreign language date formats you will need to either convert
these formats to the localized representation manually, or change
the localization of your system to match that of your data source.
Options
Popular Successors
- String to Date/Time (legacy)9 %
- Legacy Date&Time to Date&Time8 %
- Joiner3 %
- String to Date&Time3 %
Concatenate (Optional in)2 %- Column Filter2 %
- GroupBy2 %
- Excel Writer2 %
- RowID2 %
- String Manipulation2 %
XLS Writer2 %- Time Difference (legacy)2 %
- Date Field Extractor (legacy)1 %
- Rule Engine1 %
- Date&Time Part Extractor1 %
- Date&Time Difference1 %
- Date&Time Shift1 %
- Double to Integer< 1 %
- Date&Time-based Row Filter< 1 %
- Concatenate< 1 %
- Modify Date< 1 %
Row Filter (deprecated)< 1 %Number To String< 1 %- Rule-based Row Filter< 1 %
- Sorter< 1 %
- Date/Time Shift (legacy)< 1 %
- String to Number< 1 %
Column Appender< 1 %Cell Splitter< 1 %- Cross Joiner< 1 %
- Date&Time to String< 1 %
- Loop End (Column Append)< 1 %
- Number to String< 1 %
- Missing Value< 1 %
Strings To Document< 1 %- Column Filter (legacy)< 1 %
Database Update< 1 %- Column Expressions (legacy)< 1 %
- Math Formula< 1 %
- Line Plot (JavaScript)< 1 %
- Preset Date/Time (legacy)< 1 %
- ARIMA Learner< 1 %
- Time Series Generator< 1 %
Python Script (1⇒1)< 1 %Database Writer< 1 %- Java Snippet< 1 %
- Column Appender< 1 %
- Loop End< 1 %
Loop End< 1 %- Decision Tree Learner< 1 %
- Numeric Binner< 1 %
- Nominal Value Row Filter< 1 %
Joiner< 1 %Regression Predictor< 1 %- Cell Splitter By Position< 1 %
- Duplicate Row Filter< 1 %
- Table Transposer< 1 %
- Java Snippet (simple)< 1 %
Send to Tableau Server (Hyper)< 1 %- UNIX Timestamp to Date&Time< 1 %
- CSV Writer< 1 %
- Group Loop Start< 1 %
- k-Means< 1 %
Cell Replacer< 1 %- Column Resorter< 1 %
- One to Many< 1 %
- Constant Value Column< 1 %
Row Splitter (deprecated)< 1 %- Box Plot (legacy)< 1 %
- Send to Power BI< 1 %
- Value Filter (legacy)< 1 %
- R View (Table)< 1 %
- Date&Time to legacy Date&Time< 1 %
- String to Duration< 1 %
- TIBCO Spotfire File Writer< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %Table Row to Variable< 1 %- Table Row to Variable< 1 %
CSV Writer< 1 %Parameterized Database Query< 1 %- Chunk Loop Start< 1 %
- Column Renamer< 1 %
- Missing Value Column Filter< 1 %
- Pivot< 1 %
- Rank< 1 %
Column Rename< 1 %- String Replacer< 1 %
- Statistics< 1 %
- Interval Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %Python Script (1⇒1)< 1 %- Range Filter< 1 %
- 2D/3D Scatterplot< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Database Reader< 1 %Loop End (2 ports)< 1 %- Table Row to Variable Loop Start< 1 %
- Linear Regression Learner< 1 %
- Binner (Dictionary)< 1 %
- Cell Splitter< 1 %
- Column Combiner< 1 %
- Lag Column< 1 %
Linear Correlation< 1 %- Table Validator (Reference)< 1 %
- Domain Calculator< 1 %
- Extract Missing Value Cause< 1 %
- Reference Row Filter< 1 %
- Table Manipulator< 1 %
- Partitioning< 1 %
- Number to String (PMML)< 1 %
- String Manipulation (Multi Column)< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Data Explorer< 1 %
- Empty Table Switch< 1 %
- Cache< 1 %
- Color Manager< 1 %
- DB Insert< 1 %
- DB Writer< 1 %
- DB Table Creator< 1 %
- Similarity Search< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- LIBSVMPredictor< 1 %
XLS Sheet Appender< 1 %Excel Sheet Appender (XLS)< 1 %- Google Sheets Updater< 1 %
- Date&Time Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Python Script (legacy)< 1 %
Extract Date&Time Fields< 1 %- Extract Duration Fields< 1 %
- Modify Time< 1 %
- Modify Time Zone< 1 %
- Time Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Wait...< 1 %
Table Column to Variable< 1 %- ARFF Writer< 1 %
Database SQL Executor< 1 %- Column List Loop Start< 1 %
- Column Comparator< 1 %
- Column Merger< 1 %
- Number Rounder< 1 %
- Table Difference Finder< 1 %
- Crosstab< 1 %
- Parallel Chunk End< 1 %
- Counter Generation< 1 %
- Random Matcher< 1 %
Excel Writer (XLS)< 1 %- HTML Parser< 1 %
Database Looping< 1 %Database Table Creator< 1 %Generic Loop Start< 1 %Recursive Loop Start< 1 %- Edit Nominal Domain< 1 %
- Normalizer< 1 %
- Top k Row Filter< 1 %
- Ungroup< 1 %
- Extract Table Spec< 1 %
- Histogram (legacy)< 1 %
- Lift Chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
Color Appender< 1 %- DB Update< 1 %
- Bar Chart (JavaScript)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Bar Chart (JFreeChart)< 1 %
- Nominal Row Filter Configuration< 1 %
- Table to JSON< 1 %
- R Snippet< 1 %
Table to HTML String< 1 %- URL to File Path< 1 %
- Extract Variables (Data)< 1 %
Database Table Connector< 1 %Recursive Loop End< 1 %- Category to Number< 1 %
- Column Renamer (Dictionary)< 1 %
Double To Int< 1 %- Reference Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Splitter< 1 %
- Denormalizer< 1 %
String To Number (PMML)< 1 %- String Splitter (Regex)< 1 %
- Set Operator< 1 %
- Column Splitter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Rule Engine Variable (Dictionary)< 1 %
CASE Switch Data (End)< 1 %- End IF< 1 %
Merge Variables< 1 %- Scatter Matrix (legacy)< 1 %
Parquet Writer< 1 %- Parallel Chunk Start< 1 %
- DB Loader< 1 %
- Distance Matrix Calculate< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
- Value Selection (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Maximum Finder< 1 %
Python Script (2⇒1)< 1 %Python View< 1 %- GET Request< 1 %
- Date Extractor< 1 %
- Is Empty< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Uniquify IDs< 1 %
- Coordinate Row Filter< 1 %
- Number Formatter< 1 %
Graph Density Uncertainty Scorer< 1 %- ARIMA Parameter Importer< 1 %
- ARIMA Predictor< 1 %
- ARIMA Visualization< 1 %
- Create Collection Column< 1 %
- Split Collection Column< 1 %
- Breakpoint< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %- Table Column to Variable< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %- Table to Image< 1 %
Database Delete< 1 %Database Connector< 1 %- Table Writer< 1 %
List Files< 1 %Table Writer< 1 %- Table Creator< 1 %
- Java Edit Variable< 1 %
- Feature Selection Filter< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Counting Loop Start< 1 %Interval Loop Start< 1 %Recursive Loop Start (2 ports)< 1 %Variable Loop End< 1 %Naive Bayes Learner< 1 %- Fuzzy Rule Learner< 1 %
- Fuzzy Rule Predictor< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- DBSCAN< 1 %
- Decision Tree Predictor< 1 %
- Polynomial Regression Learner< 1 %
- Regression Predictor< 1 %
- Scorer< 1 %
- SMOTE< 1 %
- Association Rule Learner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
- Add Empty Rows< 1 %
- Auto-Binner< 1 %
- Create Bit Vector< 1 %
- Case Converter< 1 %
- Column Auto Type Cast< 1 %
String To Number< 1 %- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- Linear Correlation< 1 %
- Correlation Filter< 1 %
- Table Validator< 1 %
Column Filter< 1 %- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Subset Matcher< 1 %
- Normalizer (Apply)< 1 %
- Numeric Binner (PMML)< 1 %
- Missing Value (Apply)< 1 %
- Normalizer (PMML)< 1 %
Number To String (PMML)< 1 %- String to Number (PMML)< 1 %
- Numeric Row Splitter< 1 %
- Row Sampling< 1 %
- String Manipulation (Variable)< 1 %
String Replace (Dictionary)< 1 %- Unpivot< 1 %
- Rule Engine (Dictionary)< 1 %
Rank Correlation< 1 %- Kaplan-Meier Estimator< 1 %
- Numeric Outliers< 1 %
- Independent groups t-test< 1 %
- Linear Discriminant Analysis Apply< 1 %
CASE Switch Variable (Start)< 1 %- IF Switch< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
- Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- HiLite Table (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Shape Manager< 1 %
- ROC Curve (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Save Workflow< 1 %
MySQL Connector< 1 %DB Table Creator< 1 %- One Row to Many< 1 %
- Java Distance< 1 %
- Numeric Distances< 1 %
- DL Python Network Learner< 1 %
- Line Plot (Plotly)< 1 %
- PMML Predictor< 1 %
Table to PDF< 1 %- External Tool< 1 %
- Table to H2O< 1 %
- Math Formula (Multi Column)< 1 %
- HeatMap (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Ruby Script< 1 %
- Rule Viewer (local) (Legacy)< 1 %
XLS Reader< 1 %Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %- Java Edit Variable (simple)< 1 %
- Java Snippet Row Filter< 1 %
Tableau Writer (Hyper)< 1 %- Send to Tableau Server< 1 %
- Tableau Writer< 1 %
Send to Tableau Server (TDE)< 1 %Tableau Writer (TDE)< 1 %- Case Converter< 1 %
- Dictionary Replacer (File-based)< 1 %
- Strings to Document< 1 %
- JPMML Classifier< 1 %
- Table View (JavaScript)< 1 %
- JSON Path< 1 %
- JSON to XML< 1 %
- Median Filter< 1 %
Python Edit Variable< 1 %- R Learner< 1 %
- Table to R< 1 %
- Data to Report (BIRT)< 1 %
- Duration to Number< 1 %
- Create Date&Time Range< 1 %
- Moving Aggregator< 1 %
- String to XML< 1 %
Dumb Joiner< 1 %- RDKit Interactive Table< 1 %
- Latitude/Longitude to Coordinate< 1 %
Views
- This node has no views
Workflows
(Optional)_Linear_RegressionKNIME Hub- 01_Guided_AnalyticsKNIME Hub
- 01_Guided_AnalyticsKNIME Hub
- 01_Preprocessing_Time_Alignment_and_VisualizationKNIME Hub
- 01_Preprocessing_Time_Alignment_and_VisualizationKNIME Hub
- Show all 60 workflows
Links
- Converting string to datetime with “month name”by armingrudd on 2019-09-27forum.knime.com/p/71186
- can’t convert string in date timeby armingrudd on 2020-01-20forum.knime.com/p/79260
- String to Date&Time with Timezone Descriptionby izaychik63 on 2019-03-19forum.knime.com/p/56536
- Date filteringby armingrudd on 2019-06-18forum.knime.com/p/62463
- Messy Date & Time String Reformattingby mlauber71 on 2019-01-21forum.knime.com/p/53169
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.