Change DATETIME Column within the Event-Collection

Question

Hello all,

in the event-collection I create a new table, wherein I join two tables based on the following rule:

JOIN

WHERE "Alarm"."Starttime" > "Transport"."Starttime" AND "Alarm"."Starttime" < "Transport"."Endtime"

This works. Now I would like to extend this timeframe by 5 Minutes. And neither the function:

add_minutes("Transport"."Endtime", 5) is supported nor the function REMAP_TIMESTAMPS("Alarm"."Starttime") < (REMAP_TIMESTAMPS("Transport"."Endtime") + 5)

How can I change/remap a timestamp in the event collection?

Page 1 / 1

Hi Stephan,

You can use the following Vertica SQL function: link.

This function gives the ability to add/subtract amounts of time from a timestamp. You can also specify the unit, i.e., minutes in your case.

Hope this helps!

Reply

Anonymous · Answer

Hi Stephan,You can use the following Vertica SQL function: link.This function gives the ability to add/subtract amounts of time from a timestamp. You can also specify the unit, i.e., minutes in your case.Hope this helps!

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN