Skip to main content
Question

Activity Table Timestamp in Milliseconds

  • May 11, 2020 9:52 AM UTC
  • 3 replies
  • 155 views

Hey, I have a use-case where events can happen super fast. Hence, I build an activity table with a Millisecond Timestamp. When I read it in via file upload, it detects the Milliseconds with the format yyyy-mm-dd HH:mm:ss.SSS. But after loading it does not show the miliseconds in the respective timestamp column, only with seconds. Do you support Milliseconds for the timestamp column? Do you have a workaround for proper ordering, when Sorting column would not work? I would appreciate any help.

3 replies

  • Nov 12, 2020 11:57 AM UTC
Hi, Ive just thought about the same thing. You can create an OLAP table with case id and timestamp column and set the format of the timestamp to %Y-%m-%d %H:%M:%S.%L You should then see the millis. Kr, Mara

  • Aug 23, 2022 3:52 AM UTC

@lennart.lehma12  Did you ever find a solution for your issue? Or did you move forward with the solution Mara suggested? If yes, how did you get the milliseconds into Celonis?


  • Feb 15, 2023 11:01 AM UTC

@jessica.lugha @mara.aderm11 , Is there a solution to add milliseconds to data from a string conversion or in the data ingestion? I'm having trouble finding a %.... identifier for the milliseconds of a datetime