TK

Tim Knechtel on

Hi everyone! I’m working with date/time fields stored as strings in yyyyMMddHHmmss format. I can convert these values into a timestamp (for example, using TO_TIMESTAMP(...)), but I’m struggling with adding or subtracting hours/minutes from the resulting timestamp. Is there a straightforward way in ARIS Process Mining (e.g., using built-in functions, interval expressions, or something similar) to perform time arithmetic once I have a proper timestamp?

something like: TO_TIMESTAMP('20250101123000', 'yyyyMMddHHmmss') + <some_interval> --e.g. + INTERVAL 2 HOUR

or

to_timestamp(CONCAT(A.CREATIONDATE, A.CREATIONTIME), 'yyyyMMddHHmmss') + INTERVAL 2 HOUR as END_TIME,

Any examples or best practices would be greatly appreciated!

Many thanks,

Tim

 

Tags
#processmining

 or register to reply.

Notify Moderator