Time column to Military Time

KNIME Analytics Platform
1

Hi Knimers,

I have a question, I have this column:
image

But I need it as military time: (eg. 13:01:01)

I’m using String to Date & Time node, but doesn’t work
.

image
image891×456 60.4 KB

Any thoughts?

Thanks in advance :slight_smile:

2

Hi @IvaR
Have you seen this? :thinking:

2 Likes
3

You’ll need to use the pattern: hh:mm:ss a

Also, ensure to uppercase the strings, because it must be AM/PM for the parser to work.

See here for an example:

2 Likes
4

Thanks for your answer :slight_smile: but these workflows do exactly the opposite of what I need, I need the time with AM / PM to change to Military, and those workflows do it in reverse

5

Thanks for answer :slight_smile:

I change all to uppercase:
image

But still doesn’t work :frowning_face:

image
image878×403 62.4 KB

image
image884×428 76 KB

Any thoughts?

Thanks in advance :slight_smile:

6

Check the pattern, it must be as follows: hh:mm:ss a (mind the a)

Hope this helps!

– Philipp

2 Likes
7

It also includes your case. :slightly_smiling_face:
See the workflow I created:
AM PM convertor.knwf (7.8 KB)

4 Likes
8

Thank you so much :slight_smile: : :+1:

9

You got the reason!!! Thank you very much for your help and your kind answer :slight_smile: :+1:

10

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