The part "{t 946771200000 }" refers to a timestamp value in a specific format. The format "{t ... }" appears to be used to represent a timestamp in some custom or specific way, possibly because we are using string values.

Celonis uses a "Unix time," "Epoch time," or "POSIX time." timestamp i.e. the value "946771200000"is a timestamp in milliseconds since the Unix epoch (January 1, 1970, UTC). This type of timestamp is often referred to as "Unix time," "Epoch time," or "POSIX time."

Basically if you add "946771200000" milliseconds to (January 1, 1970, UTC) you should get you desired result.

Hi @Abhishek Chaturvedi 

Thank you for the explanation. If possible, can you share any documentation present - regarding the different times?

Thanks

Abhinav

Hi Abhinav,

This is not related to Celonis, to understand what is epoch time please refer to the following link

https://www.techtarget.com/searchdatacenter/definition/epoch