Is it possible to change the timezone setting on Celonis or should it be done at a transformation level?
Page 1 / 1
Hi @Sridhar Turaga,
I usually do it in transformations like this:
UPDATE "ACTIVITIES"
SET "EVENTTIME" = TIMESTAMPADD(HOUR, 5, ("EVENTTIME"))
This could be due to the sorting. Read this article: https://docs.celonis.com/en/activity-table-sorting.html
Otherwise follow the suggestion above, to add to the timestamp. Be also aware about what information you upload, and if you need to take winter and summer time into account.
Hope this helps.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.