Wrong type for Timestamp

Unfortunately searching the Community and internet didn’t get me the answer to this problem. I’m 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.