Skip to main content
Solved

What does "{t 946771200000 } " refer to? What is returned as O/P for the above part in the PQL statement -CASE WHEN "Table1"."Column1" IN ( {t 946771200000 } , {t 1009756800000 } , {t 1245145600000 } ) THEN "Table1"."Column1" ELSE null END

  • August 5, 2023
  • 3 replies
  • 11 views
A
Level 4

It is mentioned in the scenraio 5 of 'IN' Predicate function documentation page - IN (celonis.com)

 

image 

Thanks in Advance!

Best answer by abhishek.chatu14

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.

3 replies

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

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.

A
Level 4

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

abhishek.chatu14
Level 11
Forum|alt.badge.img+4

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

Community Code of ConductAccessibility statement