Icon

06_​Manipulating_​Date_​and_​Time_​Values

Manipulating Date&Time Values

This workflow shows examples of the following operations on date and time values:
- Converting date and time values from String to Date&Time
- Removing time from Date&Time values, adding a date to time values, and changing the time zone in Date&Time values with time zone
- Extracting granularities (years, months, etc.) from Date&Time values






Date&Time Manipulation:String to Date&Time Date&Time Manipulation: Modify (Remove, Add, or Replace) Time Date&Time Manipulation: Extract Date&Time Fileds (Years, Months, etc.) Date&Time Manipulation: Modify(Remove, Add, or Replace) Date Date&Time Manipulation: Modify (Remove, Add, or Replace) Time Zone This workflow shows an example of manipulating date and time values Read sales dataConvert order dateRemove timefrom order dateAdd date totimeDifferent time zone for ordersfrom the USYear and monthof ordertop: USVisualize salesby year and monthFile Reader String to Date&Time Concatenate Modify Time Modify Date Modify Time Zone Extract Date&TimeFields Row Splitter Concatenate Stacked Area Chart Preprocessing Read dailysales data Read sales data Date&Time Manipulation:String to Date&Time Date&Time Manipulation: Modify (Remove, Add, or Replace) Time Date&Time Manipulation: Extract Date&Time Fileds (Years, Months, etc.) Date&Time Manipulation: Modify(Remove, Add, or Replace) Date Date&Time Manipulation: Modify (Remove, Add, or Replace) Time Zone This workflow shows an example of manipulating date and time values Read sales dataConvert order dateRemove timefrom order dateAdd date totimeDifferent time zone for ordersfrom the USYear and monthof ordertop: USVisualize salesby year and monthFile Reader String to Date&Time Concatenate Modify Time Modify Date Modify Time Zone Extract Date&TimeFields Row Splitter Concatenate Stacked Area Chart Preprocessing Read dailysales data Read sales data

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Maarit Laukkanen
Created at: 2019-06-12
On NodePit since: 2023-11-23
Last update: 2024-11-17
Created with KNIME version: v4.1.2
Tags: data manipulationETLdata transformationdatetimetime zonegranularitydate formatdata cleaninge-learningtype conversionpreprocessing

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!