Execution error: ERROR: Function catalog.timestampadd(unknown, int, time) does not exist, or permission is denied for catalog.timestampadd(unknown, int, time)

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','hh:mm:ss'))

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 ?