Skip to main content
Unfortunately searching the Community and internet didnt get me the answer to this problem. Im trying to convert a value to date format with TO_TIMESTAMP, but the value seems to have the wrong type: LONG instead of STRING. Is there an easy way to convert LONG into STRING without changing the underlying table (i.e. involving the developer)? I see there is a function for STR_TO_INT, but not the other way around. My Celonis version is 4.5.0.
Hi @soppeneer you can convert an int to string by concatenating it with an empty string: "Table"."IntColumn" || '' Best David
@d.becher Thanks David! In retrospect I feel dumb not thinking of it. Or at least I tried a similar approach but must have had the format wrong. Case solved.
Community Code of ConductAccessibility statement