I have a time stamp in the below format in a spreadsheetYYYYMMDDHHMMSSMS.When i try to upload this sheet the MS part is cutting out. How do I upload timestamp with microseconds?

Let me guess: you upload the sheet using the upload tool into a Vertica table. Then using SQL you don't see the MS.....

If that's correct, maybe is because in SQL doesn't show the microseconds. To confirm if the microseconds have been uploaded use something like

select EVENTTIME,EXTRACT(MICROSECONDS FROM EVENTTIME) from "_CEL_AA_ACTIVITIES"

HTH

Thank you Guillermo!!

I do see the MS value when i run the query . But when i run a process explorer dont think Celonis is considering the MS values. Do you know how to fix that?

If I recall correctly, Celonis, by default, doesn't show millisecs.

To show it in, lest say, an OLAP, you need to format it specifically

I guess to show in Process Explorer you could create a custom KPI.

Anyway, I know that Celonis considers them. I remember having an activity table with millisecs and, although it didn't show them, the activities were in the right order (it was a transactional systems and most of the activities had the same hour, minute, second.. but different millisecs)

Gullihermo by chance do you have the PQL to pull the format accordingly?

I have been trying with another dataset, and I was a bit wrong (my bad):

• FORMAT doesn't support millis and microseconds https://docs.celonis.com/en/to_string.html#idm45870711075760
• There is a MILLIS operand (with ADD_MILLIS and MILLIS_BETWEEN) - https://docs.celonis.com/en/millis.html
  • But when tried to use it gives me 0 all the time (although it is supposed to have a value)
  • But I don't trust too much the dataset I am working with, so maybe it is just a glitch of my dataset....

So in theory you can NOT show the millis in a data, but you can ADDa column with MILLIS() showing only the millis part.

Also, in AF you can use millis:

https://docs.celonis.com/en/date---time-functions.html#UUID-8c999d7c-90b6-d4d4-0f6d-feeddeb89802_id_how-to-calculate-last-day-millisecond-of-month

HTH

Thank you for the udpate!!