On Sun, 14 Dec 2014 15:46:52 +0100, "Olaf Kluge check_m...@satron.de [firebird-support]" <firebird-support@yahoogroups.com> wrote: > Any ideas? > > Thank you > > > Am 12. Dezember 2014 15:15:40 MEZ, schrieb "'checkmail' > check_m...@satron.de [firebird-support]" > <firebird-support@yahoogroups.com>: >>Hello @ll, >> >>I would like to group my records by day or month. The date is saved as >>timestamp. If I do the following, >> >>SELECT EXTRACT(day FROM m.messzeit), COUNT(*) as CountMessages >>FROM te_messzeiten m >>GROUP BY EXTRACT(day FROM m.messzeit) >> >>I get all days (1 to 31), but I need group by 1.1.2014, 2.1.2014.. - >>daily >>bzw. 1 2014, 2 2014 - monthly >> >>How can I realize this? >> >>Thank you >> >>Best regards >> >>Olaf
I already answered this, 5 minutes after your initial question. See https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/125829 Mark