I have an
Event table with a
TIMESTAMP column and a
Integer column (number of seconds since event started). What I want to calculate is an event finish time =
start_time + duration in a query. Clearly
SELECT start_time + duration won’t work as there are no units but the error hints at a
<DATETIME_INTERVAL> type. There appears to be an
INTERVAL keyword but I can see how to actually use it.
Can someone provide some information as to how to use this operator.