I have an idea:

time calculations smaller than days

I report on data that is tracked smaller than days.

We need to know messages a second or minute or hour.

All your date functions are for DAYS.

I would like COUNT_MINUTES or similar for current hour and difference ranges.

This could be solved for having date conversion to UNIXTIMESTAMP and then similar to this:
SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datetime_col)

The only way at the moment is to slice the data up and this is not very practical.

1 vote
Vote
Sign in
Signed in as (Sign out)
You have left! (?) (thinking…)
Tristan Bailey shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base