i've got it:
select from_unixtime(round((ceiling(unix_timestamp(calldate)/ 900)
*900))) as intervall, count(distinct(clid)), count(clid) from cdr where
calldate > '2019-09-01' group by intervall;
Am 12.11.19 um 15:16 schrieb Andre Gronwald:
would be better to have dates starting with "2019-10-14 08:00:00",
"2019-10-14 08:15:00" etc...
any quick idea? i will search for that anyway.
regards,
andre
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
Check out the new Asterisk community forum at: https://community.asterisk.org/
New to Asterisk? Start here:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users