Not all the functions of Vertica SQL are ported to Celonis. For example MILLISECONDS() does not work

You will need some "try-and-error" to find which function is ported and can help you

For example recently we used EXTRACT(MILLISECONDS FROM TIMESTAMP) to get that info

HTH

Try using the following

ADD_DAYS

ADD_MONTHS

ADD_SECONDS

TIMESTAMPADD is supported by Celonis however not sure why you have a catalog.timestampadd can you help us with a screenshot of your query ?

Dear Abhishek,

please find the below code

Insert into "Contactcentre_Activity_table"  (     "Case_key",     "Activity_name",     "Event_time",     "Sorting"  )   SELECT  "Contactcentre_Case_table"."CALLID" as Case_key, 'Call Ring' as "Activity Name", CASE WHEN        TIMESTAMPADD(S,        DATEDIFF(S,'00:00:00',"RING TIME"::TIME),        (TIMESTAMPADD(S,        DATEDIFF(S,'00:00:00',"QUEUE TIME"::TIME),        "START TIME"))):: TIME >= (TIMESTAMPADD(S,        DATEDIFF(S,'00:00:00',"QUEUE TIME"::TIME),        "START TIME") :: TIME)      THEN        ("START DATE" :: DATE || ' ' ||        TIMESTAMPADD(S,        DATEDIFF(S,'00:00:00',"RING TIME"::TIME),        (TIMESTAMPADD(S,        DATEDIFF(S,'00:00:00',"QUEUE TIME"::TIME),        "START TIME"))        :: TIME)) :: TIMESTAMP      ELSE         ("START DATE" :: DATE + 1 || ' ' ||        TIMESTAMPADD(S,        DATEDIFF(S,'00:00:00',"RING TIME"::TIME),        (TIMESTAMPADD(S,        DATEDIFF(S,'00:00:00',"QUEUE TIME"::TIME),        "START TIME"))        :: TIME)) :: TIMESTAMP        END,  30 as Sorting from Contactcentre_Case_table;

Thank you will check it

Hi here are few things you are missing, lets say you want to add 10 seconds, this is what the query would look like

TIMESTAMPADD(s,10,TO_DATE('00:00:00','hhss'))

So the first parameter is your datepart(in this example seconds) ,

the second parameter is the time you want to add (in this example 10 seconds) and the third parameter is the date field (in this example 00:00:00).

Now in your case I see four parameters

TIMESTAMPADD(

S, -> 1

DATEDIFF(S,'00:00:00',"RING TIME"::TIME), -> 2

(TIMESTAMPADD(S,DATEDIFF(S,'00:00:00',"QUEUE TIME"::TIME), ->3

"START TIME")): TIME) -> 4

Can you validate the same ?