Hello all,
I have tried to manipulate the timestamp in SQL, which worked on our Oracle server, but seems to have no effect on the back end in EMS. I suspect there is some kind of time zone problem? I have attached a few screenshots.
The timestamp should have the following format:
Original: YYYY-MM-DD 00:00:00 --> manipulated YYYY-MM-DD 23:45:00
Thanks for your answers in advance.
With kind regards
Christoph
EMS not working
Local Database the SQL query works
Hey Christoph,
It looks like you are trying several different methods to manipulate the timestamps. Seeing as you want to achieve the 23:45 version, wouldn't it make more sense to add 1425 minutes instead of 1485. Now you are adding a day and 45 minutes to your queries.
It's interesting to me that the 'hallo' and 'test' queries actually show the 23:45:00 time, might this have something to do with timezones in some way?
Question: Do you want to achieve your transformation of timestamps in SQL or in Celonis directly?
Maurits
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
