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.