How to extract time from SAP using RFC node in correct format?

KNIME Analytics Platform
1

Hello!
I’m trying to download with KNIME 5.3 a table from SAP via the RFC node. One of the columns I need is
a time field. All the columns are extracted correctly, except for the column where I’m supposed to see the time. For
example, in SAP the time is displayed in format 04:00:00 and then in RFC node it is displayed in format 02:02:20.0. I cannot find any conversion logic to help me convert the data. Did anybody managed to extract from SAP using Knime RFC node a table with time data as per SAP? Does anybody know if there is any more recent fix or workaround available? My goal is to make it work using only Knime. Thank you!

2

Hi, I am not familiar with RFC node but if you are getting string values like 02:02:20.0, then you could use String to Date&Time – KNIME Community Hub node to easily convert them to Date&Time values in KNIME.

Choose “Time” in the new type list, and change the format code to “HH:mm:ss.S” - if you encounter errors then just modify the code to match all rows.

The help content of String to Date&Time explains quite well on what do the letters represent in the format code.