Convert AM/PM to proper time

KNIME Analytics Platform
1

Hi I'm knew to KNIME.  How do I convert "PM" to hour 00-23 format? Example - 02/25/2016 10:35:00 PM into 02/25/2016 22:35:00?

Your help is much appreciated!!

2

Hi Caby454,

Please find attached an example workflow.

Hope this helps!

Best,

Vincenzo

1 Like
3

Super helpful - thanks!

4

Looks like last node in the lower line is not working.

5

Dear @izaychik63

Please find the updated example workflow attached. Now everything should work.
convert_-_am-pm_to_proper_time.knwf (35.1 KB)

FYI: For KNIME Analytics Platform 3.4 release we did a full rewrite of our Date and Time support. You may want to have a look at the new nodes available in the node repository and also at the following blog post that provides an intro to the new Date & Time integration and its features:

Hope this helps!
Best,
Vincenzo

2 Likes