Group by minute
931228Apr 17 2012 — edited Apr 20 2012Hello,
I want to count the entries of one table of each minute and I don't get it running.
My solution for counting the entries per day works fine with:
SELECT
TO_CHAR(sendtime,'YYYYMMDD') as Day, count (*) as Count
FROM
myTable
WHERE
creationtime>= '10.04.2012'
and creationtime<= '18.04.2012'
GROUP BY
TO_CHAR(sendtime,'YYYYMMDD')
ORDER BY
TO_CHAR(sendtime,'YYYYMMDD')
Simply adding "HH:MM" (using TO_CHAR(sendtime,'YYYYMMDD HH:MM')) does not work.
Does someone have a tip how it should work?
Greetings
oetzi