how to sum timestamps by 5 minutes

Question

I need help with taking sum of timestamps in sql by 5 mins or since I'm doing analysis so maybe i change it to 6, 7 or 10 mins , particularly in Exasol as it doesn't have all functions like datediff and dateadd.

the result should look like this :

will be helpful .

Explain how the expected result match your question. The difference is much more than 5 minutes. — Salman A, Jan 19 '22 at 08:12
Assuming that these are stored as `datetime` in MySQL, where/what are the hours for each date? — Salman A, Jan 19 '22 at 08:40

score 1 · Answer 1 · answered Jan 19 '22 at 08:57

Exasol has functions similar to datediff and dateadd: MINUTES_BETWEEN and ADD_MINUTES

My solution is based on this SO question:

select add_minutes (
        trunc (CONTACT_DATE, 'mi'),
        mod (extract (minute from CONTACT_DATE), 5)
    ) as START_TIME
    , count (*) as CNT
from visits
group by local.START_TIME

Here 5 is a constant which defines length of period in minutes.

how to sum timestamps by 5 minutes

1 Answers1