Hub
NodeNode / Manipulator

String to Date&Time

streamable

Parses the strings in the selected columns and converts them into Date&Time cells using the provided format pattern.
Since dates may contain localized terms such as month or weekday names, you can select a locale.

Node details

Input ports
  1. Input table Type: Data
    Input table.
Output ports
  1. Output table Type: Data
    Output table containing the parsed columns.

Related workflows & nodes

  1. Solution to the Exercise 1: Loading and Exploring Data
    Time Series Energy Usage Education +2
    This workflow accesses, preprocesses, and visualizes time series (energy consumption) data by - converting time values …
    knime > Education > Courses > L4-TS Introduction to Time Series Analysis > Solutions > Session_1 > 01_Load_Clean_and_Explore
  2. Accessing, Transforming and Modeling Time Series
    time series ARIMA granularity +5
    This workflow shows how to access time series data, make it equally-spaced, impute missing values, aggregate it at a gr…
    knime > Examples > 04_Analytics > 07_Time_Series > 04_Example_of_Time_Series_Application_with_Components > 01_Accessing_Transforming_and_Modeling_Time_Series
  3. TweetKollidR
    Twitter visualisation network +2
    A workflow to collect and visualise data from Twitter. Using the Twitter API, this workflow retrieves tweets that match…
    angusveitch > Public > TweetKollidR
  4. Accessing, Transforming and Modeling Time Series
    time series ARIMA granularity +5
    This workflow shows how to access time series data, make it equally-spaced, impute missing values, aggregate it at a gr…
    rriedel > Public > 01_Accessing_Transforming_and_Modeling_Time_Series
  5. Inventory Optimization Use Case: Data Preparation, Modeling and Business Logic Workflow
    Retail
    Inventory supply and consumption data is loaded, prepared and later forecasted using ARIMA providing the primary output…
    knime > Examples > 50_Applications > 41_Inventory_Optimization > 01_Data_Preparation
  6. Rossmann - DB - Time Series(2)
    mwysocki > Public > Rossmann - DB - Time Series(2)
  7. Rossmann - DB - Time Series
    mwysocki > Public > Rossmann - DB - Time Series
  8. Deal with (messy) Time formats containing AM/PM distincions
    am pm date +3
    Deal with (messy) Time formats containing AM/PM distincions
    mlauber71 > Public > kn_example_date_time_am_pm_format
  9. Rossmann - Analiza szeregów czasowych
    mateuszwysocki > Public > Rossmann - Analiza szeregów czasowych
  10. TR_Reports_IncidentMetric3
    lp00557408 > Public > TR_Reports_IncidentMetric3