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
Tim Knechtel Author on
This question relates to handling timestamps during the dataset transformation step.
One potential workaround is using Unix time, although even this seems somewhat limited. I've noticed that the function
from_unixtime()is available, but the correspondingto_unixtime()function seems to be missing.How do you usually manage data collected from multiple time zones? Perhaps I'm overlooking something obvious.
Maybe someone from the ARIS team can provide guidance or support? Any ideas or suggestions would be greatly appreciated!