Icon

1. DateTime_​Manipulation

DateTime Manipulation
Workflow: Date&Time Manipulation This workflow shows:- how to generate Date&Time objects (columns) fromString Columns or generating date/time series artificially;- a few Date&Time manipulation nodes, to modify andshift the Date&TIme object back and forth in time read filesales.csvin KCBdata folderwrite tonew_sales.csv fileconvert String column "date" to a DateTime columnconvert DateTime column"date" back to a String type columnmove all DateTime values in column of +1 dayadd fixed time 15:00to each date asdd.mm.yyyy 15:00generates a sequence ofequally spaced dates between01.01.2009 and 01.01.2011 File Reader CSV Writer String to Date&Time Date&Time to String Date&Time Shift Modify Time Create Date&TimeRange Workflow: Date&Time Manipulation This workflow shows:- how to generate Date&Time objects (columns) fromString Columns or generating date/time series artificially;- a few Date&Time manipulation nodes, to modify andshift the Date&TIme object back and forth in time read filesales.csvin KCBdata folderwrite tonew_sales.csv fileconvert String column "date" to a DateTime columnconvert DateTime column"date" back to a String type columnmove all DateTime values in column of +1 dayadd fixed time 15:00to each date asdd.mm.yyyy 15:00generates a sequence ofequally spaced dates between01.01.2009 and 01.01.2011File Reader CSV Writer String to Date&Time Date&Time to String Date&Time Shift Modify Time Create Date&TimeRange

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2020-05-26
Last update: 2024-04-29
Created with KNIME version: v4.1.2
Tags: KNIME Advanced LuckBooksDate TimeDateTimeETL

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

Try NodePit Runner!