Icon

Manipulating timestamp to separate date and time

Get date and time from timetamp

Duplicate a timestamp column and then convert timestamp to date-only and time-only

Sample dataThis will clone the existing full timestampcolumn to a newScanning TimestampcolumnThis will remove timefrom existingscanning datecolumnThis can copy just hh:mm:ss.SSS to anew columnMake datetime intoa stringand specify time in the output format as hh:mm:ss(i.e. without the milliseconds)Convert String to DateConvert String to hh:mm:sstidy uptidy upTable Creator Rule Engine Modify Time Modify Date Date&Time to String String to Date&Time String to Date&Time Column Rename Column Filter Sample dataThis will clone the existing full timestampcolumn to a newScanning TimestampcolumnThis will remove timefrom existingscanning datecolumnThis can copy just hh:mm:ss.SSS to anew columnMake datetime intoa stringand specify time in the output format as hh:mm:ss(i.e. without the milliseconds)Convert String to DateConvert String to hh:mm:sstidy uptidy upTable Creator Rule Engine Modify Time Modify Date Date&Time to String String to Date&Time String to Date&Time Column Rename Column Filter

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: bbate
Created at: 2023-07-27
On NodePit since: 2023-07-28
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!