String to Date&Time

KNIME Analytics Platform
1

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

I tried String to Date&Time, but doesn’t work. thanks.

image

2

Hi @My_Rebecca

Welcome to the forum! :slight_smile:
You can use the String Manipulation node to join the columns together to one larger string including the date and time separators, which can then be transformed by the String to Date&Time node (I assumed you have read in the data from Excel already).

I attached you a small workflow demonstrating how to do it
DateAndTimeFromStringColumns.knwf (8.4 KB)

Hope that helps!
Best,
Alice

3 Likes
3

Hi @My_Rebecca & welcome to the KNIME forum community

Complementary to @Alice_Krebs solution, you can find here a workflow that shows how to do this operation backwards and forward, and that handles the case were the date & time fields are not represented by two digits but just one:

image
image1738×348 98.2 KB

Hope it helps too :wink:

Best
Ael

2 Likes
4

Hi @Alice_Krebs , thanks for your reply. Your workflow is OK, but strange result confuses me. Previous same time appears different. Why it happens? I need to delete the second same “GR Number” in the column, only preserve the first line. How to proceed? thanks.

image
image1707×706 401 KB

5

Try the Duplicate Row Filter.

1 Like
6

although it appears all “13:00:00”, but they’re different at about 8 digit, very tiny difference.

7

Filter on the GR Number.

8

@My_Rebecca you could take a look at this article:

If it is a more complicated task of de-duplications window functions are one option:

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.