How to extract time from SAP using RFC node in correct format?
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!