Icon

20221230 Pikairos String to Date and Time

This workflow brings a possible answer to question asked in post #57772 on the KNIME forum:

I’m starter to use Knime. How to convert string to date&time?

Dummy DatesExtractYear - Month - Day - Hour - MinuteCombineYear - Month - Day - Hour - MinuteRecompose again& convert toDate & TimeThis String Manipulationmakes sure thatMonth, Day,Hour & Minuteare made of 2 charactersTable Creator String to Date&Time Extract Date&TimeFields Column Combiner String to Date&Time String Manipulation(Multi Column) Dummy DatesExtractYear - Month - Day - Hour - MinuteCombineYear - Month - Day - Hour - MinuteRecompose again& convert toDate & TimeThis String Manipulationmakes sure thatMonth, Day,Hour & Minuteare made of 2 charactersTable Creator String to Date&Time Extract Date&TimeFields Column Combiner String to Date&Time String Manipulation(Multi Column)

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: Molina
Created at: 2022-12-30
On NodePit since: 2022-12-30
Last update: 2024-04-30
Created with KNIME version: v4.5.2
Tags: DateTimeString to Date & Time

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

Try NodePit Runner!