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.
Page 1 / 1
Hi @soppeneer
you can convert an int to string by concatenating it with an empty string:
Best
David
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.