Hello Mark,
I don’t know why, but I haven’t get this e-mail. Thank you very much! Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Montag, 15. Dezember 2014 09:00 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] group by date On Sun, 14 Dec 2014 15:46:52 +0100, "Olaf Kluge <mailto:check_m...@satron.de> check_m...@satron.de [firebird-support]" < <mailto:firebird-support@yahoogroups.com> firebird-support@yahoogroups.com> wrote: > Any ideas? > > Thank you > > > Am 12. Dezember 2014 15:15:40 MEZ, schrieb "'checkmail' > <mailto:check_m...@satron.de> check_m...@satron.de [firebird-support]" > < <mailto:firebird-support@yahoogroups.com> 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