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.

Input ports
  1. Input table Type: Data
    Input table.
Output ports
  1. Output table Type: Data
    Output table containing the parsed columns.
  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. 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
  4. Rossmann - DB - Time Series(2)
    mwysocki > Public > Rossmann - DB - Time Series(2)
  5. Rossmann - DB - Time Series
    mwysocki > Public > Rossmann - DB - Time Series
  6. TR_Reports_IncidentMetric3
    lp00557408 > Public > TR_Reports_IncidentMetric3
  7. Customer prediction with H2O in KNIME
    The purpose of this workflow is to showcase the ease of use of the H2O functionalities from within KNIME. As a real wor…
    knime > Examples > 04_Analytics > 15_H2O_Machine_Learning > 07_Customer_prediction_with_H2O
  8. Rossmann - Analiza szeregów czasowych
    mateuszwysocki > Public > Rossmann - Analiza szeregów czasowych
  9. Read an XLS file
    reading XLS excel +7
    This workflow demonstrates how to read an XLS file using the XLS Reader node. It contains three workflows. The goal of …
    lcs > Public > 01_Data_Access > 01_Common_Type_Files > 07_Reading_Excel_Files
  10. JHU_COVID_data_prep
    mraraman > Public > adhocs > JHU_COVID_data_prep