Skip to main content
Question

Wrong type for Timestamp

  • January 28, 2021
  • 2 replies
  • 16 views

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.

2 replies

Forum|alt.badge.img+2
Hi @soppeneer you can convert an int to string by concatenating it with an empty string: "Table"."IntColumn" || '' Best David

  • Author
  • Level 3
  • February 11, 2021
@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.